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?
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 <indexname> REBUILD;
Any help please write to me at