RE: How to recreate sys schema in Oracle 8i?
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <sjaffarhussain@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Jun 2007 07:36:51 -0400
Syed,
Find your latest backup and restore the database. If the SYS objects
are gone (like TAB$), then you are screwed. You have no other way to
recover from this.
Second, take all SYS privs away from everyone. *NOBODY* should be able
to connect as SYS except you. This is the reason why.
Tom
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Syed Jaffar Hussain
Sent: Tuesday, June 26, 2007 12:44 AM
To: oracle-l
Subject: How to recreate sys schema in Oracle 8i?
Hi,
Accidently, a developer ran a procedure to delete all objects exists in
SYS schema. His intention was to do the same to an application user,
but, he run it on sys schema.
In this situation, running catalog, catproc will help to stable the
situation?
I suspect that when catlog and catproc are run, there will no metada
available of existing uses, tablespace, datafiles and etc.
Is there any way to come out of this situation?
Any ideas?
--
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA
http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
------------------------------------------------------------------------
----------
"Winners don't do different things. They do things differently."
Other related posts:
