Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to recreate sys schema in Oracle 8i?

How to recreate sys schema in Oracle 8i?

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Tue, 26 Jun 2007 07:44:00 +0300
Message-ID: <97b7fd2f0706252144u6f5aefefq3d4b7e010ed2d4b9@mail.gmail.com>


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."

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 25 2007 - 23:44:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US