Home » RDBMS Server » Server Administration » object necessary for warmstarting database cannot be altered
object necessary for warmstarting database cannot be altered [message #303956] Mon, 03 March 2008 07:31 Go to next message
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,
Re: object necessary for warmstarting database cannot be altered [message #303959 is a reply to message #303956] Mon, 03 March 2008 07:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
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
Re: object necessary for warmstarting database cannot be altered [message #304051 is a reply to message #303959] Mon, 03 March 2008 22:08 Go to previous messageGo to next message
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,
Re: object necessary for warmstarting database cannot be altered [message #304068 is a reply to message #303956] Mon, 03 March 2008 23:26 Go to previous messageGo to next message
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]
Re: object necessary for warmstarting database cannot be altered [message #304086 is a reply to message #303959] Tue, 04 March 2008 00:16 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Can we make the system tablespace to offline, if means pls give the correct syntax for it in SYS schema

thanks,
Re: object necessary for warmstarting database cannot be altered [message #304092 is a reply to message #304086] Tue, 04 March 2008 00:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: object necessary for warmstarting database cannot be altered [message #304095 is a reply to message #304092] Tue, 04 March 2008 00:43 Go to previous message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Thanks a lot

Thanks,

Previous Topic: patch install?
Next Topic: autoextend on tablespace with multiple datafiles
Goto Forum:
  


Current Time: Fri Dec 02 22:55:20 CST 2016

Total time taken to generate the page: 0.09248 seconds