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?
no the table wont be re-organized - that is not true
Originally Posted by CaptainHaddock
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.
Click Here to Expand Forum to Full Width