-
export/import in 10g reorganizing the table
I came to know that while exporting and importing the data into a new database in 10g the table will be reorganized as part of this process. Is this correct? If yes, my question will be
how does an export/import "guarantee" 100% every time that a re-order of the table by PK has taken place?
regards
-
no the table wont be re-organized - that is not true
-
Originally Posted by CaptainHaddock
how does an export/import "guarantee" 100% every time that a re-order of the table by PK has taken place?
It doesn't.
Not that kind of reorganization, you can achieve defragmentation in both table and indexes by exp/imp the table but re-ordering? nahhh
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|