TABLE REORG

[edsperez]

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

[oratune]

Truncating the table should be sufficient. And, after dropping the indexes the import should recreate them for you.

[gpsingh]

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.

[marist89]

What version? If you are on 8.1.x, you don't have to do this procedure to rebuild tables; use MOVE and REBUILD.