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

Dear Oracle Experts,

If I just needed to recreate an existing table and its index with new storage attributes, what should I base on in determining the initial and next extent size of the table and its index?

Besides, 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

Thanks

Herman Received on Sat Mar 20 2004 - 07:42:11 CST