-
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.
Thx
Ed
-
Truncating the table should be sufficient. And, after dropping the indexes the import should recreate them for you.
-
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.