Home » RDBMS Server » Server Administration » changing default storage
changing default storage [message #56342] Thu, 20 March 2003 14:42 Go to next message
Joan
Messages: 36
Registered: February 2002
Member
I need to change my default storage freelist for my indexes. alter index (index_name) modify default storage ( freelist 10)... bu I am getting errors.. I believe is syntax issue but kind find right syntanx... I need to changes to reflect in user_part indexes table

Report message to a moderator

Re: changing default storage [message #56345 is a reply to message #56342] Sun, 23 March 2003 22:40 Go to previous message
Deepa
Messages: 269
Registered: November 2000
Senior Member
ALTER INDEX schema.index
STORAGE(FREELISTS n)

Report message to a moderator

Previous Topic: Creation of database on sun solaris (urgent)
Next Topic: Oracle Data Migration Assistant error : ORA-01041 internal error hostdef extenstion doesn't exist
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:58:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.