Re: How to determine the initial and next extent size of a table/ index?

Herman,
>will there be any problem (e.g. dependency problem) for the
>following two methods to recreate a table/ index?
>1. export the data, truncate the table, alter the table with a new
>storage attributes, import the data
>2. create another table (with new storage attributes) with subquery
to
>copy the existing table, drop the old table, rename the new table

Instead of the above methods, you have a simple method of table re-organization, ALTER TABLE .. MOVE .. (followed by index rebuild)

regards
Srivenu Received on Mon Mar 22 2004 - 01:47:28 CST