Fragmentation in Primary Key

Hi,

I have been trying to eliminate fragmentation in objects in the database. I noticed that one of my primary keys are fragmented. I just wanted to confirm whether I rebuild them exactly the way I rebuild regular indexes?

Thanks in advance,
Nirasha

I guess you can rebuild primary key just like regular indexes.

Rebuild the index associated with the primary key. To defarg the segment you should rebuild it with proper storage paramters according to the index size.

Hi,
This is Rohit Nirkhe,OCP from India.When u create a primary key Oracle automatically creates an index with the name of the primary key constraint.
U can find out the name of index and other information from dba_indexes and analyze the index.
U can rebuild the index with the following command
ALTER INDEX REBUILD;

Any help please write to me at
[email protected]

Starting from 8i, an index on PK is not mandatory.

You can have a PK without index.