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

Well, unfortunately, there was no DBA working at the shop. Developers were handling the database.
The developer had open two sql connections, one with sys schema and another with application schema.
Instead of running the dynamic script of delete all the objects in the application, he accidentally ran in the sys schema. I am sure, they gonna learned the lesson and will never do the again.

On 6/26/07, Mercadante, Thomas F (LABOR) < Thomas.Mercadante_at_labor.state.ny.us> wrote:
>
> Don't forget to fix your security hole so that your developer cannot do
> this again! Change the SYS password now!
>
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Syed Jaffar Hussain
> *Sent:* Tuesday, June 26, 2007 2:02 PM
> *To:* Shamsudeen, Riyaj
> *Cc:* oracle-l
> *Subject:* 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."
>

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