Alter Initial Extent Size [message #321563] |
Tue, 20 May 2008 13:51 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dineshcr
Messages: 8 Registered: November 2006
|
Junior Member |
|
|
Hi: I want to alter the initial extent size of the table.
When I try the following command:
alter table XXX STORAGE (INITIAL 128K);
I go the following error:
ORA-02203 INITIAL storage options not allowed
Cause
An attempt was made to alter the INITIAL storage option of a table, cluster, index, or rollback segment. These options may only be specified when the object is created.
Is it NOT possible to alter the Initial extent size of the table OR do I need to use any other command.
Thanks
|
|
|
|
Re: Alter Initial Extent Size [message #321572 is a reply to message #321565] |
Tue, 20 May 2008 14:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dineshcr
Messages: 8 Registered: November 2006
|
Junior Member |
|
|
Table was originally created in Tablespace A (which is defined with EXTENT MANAGEMENT LOCAL UNIFORM SIZE 4906K)
and then moved to Tablespace B ( defined as EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K )
Now the table Initial extent is set at 4096K and NEXT EXTENTS are defined as 128K.
I want to update the Initial extent to 128K is it possible?
|
|
|
|
Re: Alter Initial Extent Size [message #321647 is a reply to message #321575] |
Tue, 20 May 2008 23:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Dipali Vithalani
Messages: 278 Registered: March 2007 Location: India
|
Senior Member |
|
|
It is the size of the first extent allocated for your object. And you cannot change the size of extent already allocated to object.
Seems You need to reset the size of NEXT exitents allocated for your object.
Regards,
Dipali
|
|
|