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

"Herman" <herman.lam_at_eds.com> wrote in message news:e08e1f56.0403200542.69a3ba65_at_posting.google.com...
> 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

use LMT's then you dont have to worry about storage clauses

also you cannto alter the initial extent of a table so first method wont work really Received on Sat Mar 20 2004 - 08:00:46 CST