Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to determine the initial and next extent size of a table/ index?
"DJ" <nospamplease_at_goaway.com> wrote in message news:<R7Y6c.33$Aq3.26_at_newsfe3-win.server.ntli.net>...
> "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
Thanks Received on Sun Mar 21 2004 - 05:56:39 CST