Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rebuilding indexes after importing...

user12159859Nov 13 2009 — edited Nov 13 2009
My coworker and I are discussing whether it is necessary, or advised, to rebuild indexes after an import of the schema.

My thinking is that the index data is put into fresh blocks thereby creating a very flat index tree without any fragmentation.
But my coworker suspects that perhaps the blocks are built exactly as they existed in the source database.

I could understand, perhaps, if the refresh were done by using RMAN which copies block by block, but even then I'm not sure.

Can you help us understand this please?

Thanks.

Ed
This post has been answered by ji li on Nov 13 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2009
Added on Nov 13 2009
3 comments
3,390 views