Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problems with Storage Cluase

422674Jan 26 2005 — edited Jan 26 2005

Hi,

I have problem with the storage cluase on tables and tablespaces.

When I want to change the max_extents value I get an an ora error.

ALTER tablespace TEST storage ( maxextents 999)
/
ORA-02142 Not a valid alter tablespace option

It is an locally managed tablespace.

When I want to change the table extent option , the message is

ORA - 25150 Alter Extent Option not allowed

thank for any help
marcel

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 23 2005

Added on Jan 26 2005

#general-database-discussions

1 comment

200 views