Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to determine the initial and next extent size of a table/ index?

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

From: DJ <nospamplease_at_goaway.com>
Date: Sat, 20 Mar 2004 14:00:46 -0000
Message-ID: <R7Y6c.33$Aq3.26@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 Received on Sat Mar 20 2004 - 08:00:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US