Home » RDBMS Server » Server Administration » Alter Initial Extent Size (Oracle 10g)
Alter Initial Extent Size [message #321563] Tue, 20 May 2008 13:51 Go to next message
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 #321565 is a reply to message #321563] Tue, 20 May 2008 13:54 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Hi: I want to alter the initial extent size of the table.
This makes NO sense.
The object already exists.

Exactly what do you hope to accomplish?
Re: Alter Initial Extent Size [message #321572 is a reply to message #321565] Tue, 20 May 2008 14:14 Go to previous messageGo to next message
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 #321575 is a reply to message #321572] Tue, 20 May 2008 14:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: Alter Initial Extent Size [message #321647 is a reply to message #321575] Tue, 20 May 2008 23:24 Go to previous message
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
Previous Topic: BIN$ in Tablespace but not Recyclebin. How to Drop?
Next Topic: Related to Cursor
Goto Forum:
  


Current Time: Sat Dec 10 09:25:17 CST 2016

Total time taken to generate the page: 0.27884 seconds