Database Backup and Recovery (MOSC)

MOSC Banner

droped sys object

edited Mar 22, 2012 2:53PM in Database Backup and Recovery (MOSC) 9 commentsAnswered
Hi,

we have dropped some sys objects accidentally, we are getting the following error,could someone help on this ,

SQL> select * from recycle_bin;
select * from recycle_bin
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from recyclebin;
select * from recyclebin
              *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

AERT LOG:ORA-28 : opiodr aborting process unknown ospid (17733_1)

We stiill have the backup to restore but it will consume time,is there anyother way that we can recover it.pl help urgent

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center