Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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." -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 25 2007 - 23:44:00 CDT
![]() |
![]() |