Home » RDBMS Server » Server Administration » alter table storage parameters
alter table storage parameters [message #124155] Thu, 16 June 2005 11:02 Go to next message
Zakkhalid
Messages: 47
Registered: April 2005
Member
I have table that has 1m+ records in it.., so I don't really want to drop it and recreate...but I want to change the initial, next and maxextents in one command...

alter table x storage(initial 1m next 1m ...

doesn't seem to work..

thanking you all inadvance...

Report message to a moderator

Re: alter table storage parameters [message #124158 is a reply to message #124155] Thu, 16 June 2005 11:13 Go to previous messageGo to next message
macdba
Messages: 27
Registered: May 2005
Location: US
Junior Member
The storage parameters INITIAL and MINEXTENTS cannot be altered.

You can try moving the table using
ALTER TABLE table_name MOVE STORAGE ( INITIAL ...
NEXT ...
MINEXTENTS ...
MAXEXTENTS ...
PCTINCREASE ... )

Report message to a moderator

Re: alter table storage parameters [message #124162 is a reply to message #124155] Thu, 16 June 2005 11:31 Go to previous messageGo to next message
Zakkhalid
Messages: 47
Registered: April 2005
Member
ahhh interesting .. thank very much...

Report message to a moderator

Re: alter table storage parameters [message #124165 is a reply to message #124162] Thu, 16 June 2005 11:51 Go to previous messageGo to next message
macdba
Messages: 27
Registered: May 2005
Location: US
Junior Member
One thing I forgot to mention, once u move the table, indexes become INVALID for that table. So make sure u rebuild all the indexes associated with that table.

Report message to a moderator

Re: alter table storage parameters [message #124379 is a reply to message #124155] Fri, 17 June 2005 16:08 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
If you are using LMT like you should be, most of these values are irrelevent. People just LOVE hanging onto those legacy storage parameters, don't they?

Report message to a moderator

Previous Topic: What is recommended size of SGA (Merged)
Next Topic: tablespace efficiency
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 02:22:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.