I am doing a table and index reorg using this procedure
1. Export the table data
2. Drop the indexes
3. Truncate the tables
4. Import the data
5. rebuild/re-create the indexes
Is truncating the table enough or do I need to drop and re-create the table.
Can anyone suggest me of a more efficient way of doing this.
Truncating the table should be sufficient. And, after dropping the indexes the import should recreate them for you.
David D. Fitzjarrell
Oracle Certified DBA
Truncate shall push the HWM of table to the initial extent.
If the idea is to change the initial extent size and other storage parameters, then u need to
drop the table.
Also truncate is an nologgin operation.
What version? If you are on 8.1.x, you don't have to do this procedure to rebuild tables; use MOVE and REBUILD.
Click Here to Expand Forum to Full Width