OraFAQ Forum: Server Administration » object necessary for warmstarting database cannot be altered

Home » RDBMS Server » Server Administration » object necessary for warmstarting database cannot be altered

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

object necessary for warmstarting database cannot be altered [message #303956]

Mon, 03 March 2008 07:31

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi,
I get the following error while using DBMS_REPAIR package

ORA-00701: object necessary for warmstarting database cannot be altered
ORA-06512: at "SYS.DBMS_REPAIR", line 418
ORA-06512: at line 13
pls give me a correct solution regarding this issue

Thanks,

Report message to a moderator

Re: object necessary for warmstarting database cannot be altered [message #303959 is a reply to message #303956]

Mon, 03 March 2008 07:52

Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Some SYS objects can't be altered and so you can't execute this package on them.

Regards
Michel

Report message to a moderator

Re: object necessary for warmstarting database cannot be altered [message #304051 is a reply to message #303959]

Mon, 03 March 2008 22:08

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi,
I need to know whether the clustered table in the SYS schema can be droped or altered ,when I try to drop it it throws the same error
ORA-00701: object necessary for warmstarting database cannot be altered
so pls give the correct solution for this issue

Thanks,

Report message to a moderator

Re: object necessary for warmstarting database cannot be altered [message #304068 is a reply to message #303956]

Mon, 03 March 2008 23:26

mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai

Member

It appears you are attempting to alter/drop some sys object [SYS.OBJ$], which you are not allowed.As Michel have highlighted in previous post you can not alter objects which are listed
in bootstrap segment of your controlfile as they are necessary/required for correct functioning of database. If this is not your case than you are requested to post further details
such as object name along with database version & platform. If you are sure that operation you performed on with DBMS_REPAIR was an user object then also it is not a good practice to
keep user objects in SYS schema.

Regards

Manjit Kumar [mkbhati]

Report message to a moderator