Re: How to recreate sys schema in Oracle 8i?

Thanks all for your valuable inputs.

Luckily, they had application schema logical backup (export). I did the following and able to bring it everything back to normal business:

Created a new database.
Created application tablespaces.
Restore the application schema.

Regards

Jaffar

On 6/26/07, Shamsudeen, Riyaj <RS2273_at_att.com> wrote:
>
> I am not sure whether procedure successfully completed or not. Can you
> confirm ? Also Is the DB open ? If yes, try to see what sys objects are
> missing. If I remember correctly, many sys objects can be dropped, but some
> can't be. Hopefully, procedure was written without exception handlers and so
> may have stopped in the middle.
>
>
>
> You could possibly export what you need and then recreate or restore.
>
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Syed Jaffar Hussain
> *Sent:* Monday, June 25, 2007 11:44 PM
> *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."
>
>
>

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