OraFAQ Forum: Server Administration » Modify default attributes

Home » RDBMS Server » Server Administration » Modify default attributes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Modify default attributes [message #57304]

Wed, 04 June 2003 10:08

Jian
Messages: 4
Registered: May 2003

Junior Member

alter index emp_pk modify default attributes freelists 2

ERROR at line 1:
ORA-14121: MODIFY DEFAULT ATTRIBUTES may not be combined with other operations

Wha is wrong with this syntax

Report message to a moderator

Re: Modify default attributes [message #57310 is a reply to message #57304]

Thu, 05 June 2003 00:24

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I think you're missing the keyword "STORAGE", which would make your statement more like this:

ALTER INDEX emp_pk MODIFY DEFAULT ATTRIBUTES <B>STORAGE (</B>FREELISTS 2<B>)</B>;

Hth,
MHE

Report message to a moderator

Previous Topic:	Forgot password
Next Topic:	Cron job

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:42:19 CDT 2024