Home » RDBMS Server » Backup & Recovery » Drop Dual/User_objects
icon2.gif  Drop Dual/User_objects [message #210920] Sat, 23 December 2006 05:06 Go to next message
harpreetsinghkup
Messages: 52
Registered: May 2006
Location: Mumbai
Member

i drop dual table from the sys's account.
and user_object from a spacific user account.
now my database is mounted, but not opened.
i want to open my database without re-create new database.
it can be possible.??
can i recover it?,by using some spacific commands
Please help me.
thanks in advance
Harpreet Singh
Re: Drop Dual/User_objects [message #210922 is a reply to message #210920] Sat, 23 December 2006 05:37 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
how come you achieved deleting the dual table?and what were you trying to do actually?
Re: Drop Dual/User_objects [message #210925 is a reply to message #210920] Sat, 23 December 2006 05:47 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Great. You broke your database. You did physically drop DUAL? Why on earth did you drop anything under SYS? I hope that you don't do this for a living. SYS is a maintenance account (the dictionary owner), you don't mess with it. A full restore might be an option, if you have a backup...

I hope that you don't have privileges on a production machine.

MHE
Re: Drop Dual/User_objects [message #210937 is a reply to message #210920] Sat, 23 December 2006 22:14 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

when you try to open your database any error you getting if yes plz. post here.

and also post last few lines of alert.log file. ( oraclehome/admin/<sid>/bdump/alert.log)


regards
Taj
Re: Drop Dual/User_objects [message #211095 is a reply to message #210922] Tue, 26 December 2006 05:39 Go to previous messageGo to next message
harpreetsinghkup
Messages: 52
Registered: May 2006
Location: Mumbai
Member

i was go to sys's account and drop the dual table from here.
do't worry amul, it is not a production database.
it is only for r&d.
now my database is in the mount stage not in opened stage.
can i open it or not...??
if yes then how??
please tell me.
Thanks in advance.
Re: Drop Dual/User_objects [message #211100 is a reply to message #211095] Tue, 26 December 2006 06:16 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Depends on the oracle version.
http://govt.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1562813956388#6994449306767

PS:
Dropping the SYS objects are just about bad & nasty things to do.
Last time that was done, we almost fired the so called 'DBA'.
Previous Topic: Urgent help need .... backup/restore with RMAN from another host ...
Next Topic: How to set a cronjob
Goto Forum:
  


Current Time: Wed Dec 07 16:33:04 CST 2016

Total time taken to generate the page: 0.09382 seconds