Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: extent
Unfortunately, the answer is no. Not directly at least. You can use
the create table as select .. statement to create a new table with the
correct initial extent size, then drop the original table and rename
the new table. Be sure to note indexes, constraints, triggers,
dependicies etc. before doing this.
Or, you could export the table with compress=Y, drop the table,then
import the table. This will attempt to create the table with all data
in one extent, so be sure you have an extent that is big enough.
Depending on the verion of Oracle you are running, there may be other
ways to achieve this also.
HTH,
Patrick
In article <vT0m5.2616$R87.51152_at_sjc-read>,
"SP" <sdpant_at_yahoo.com> wrote:
> Oracle experts:
> Is it possible to modify the size of initital extent of a table with
a alter
> table (or any) command?
> TIA
> SP
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Aug 14 2000 - 21:02:44 CDT