OraFAQ Forum: Backup & Recovery » Drop Dual/User

Home » RDBMS Server » Backup & Recovery » Drop Dual/User_objects

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Drop Dual/User_objects [message #210920]

Sat, 23 December 2006 05:06

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

Report message to a moderator

Re: Drop Dual/User_objects [message #210922 is a reply to message #210920]

Sat, 23 December 2006 05:37

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?

Report message to a moderator

Re: Drop Dual/User_objects [message #210925 is a reply to message #210920]

Sat, 23 December 2006 05:47

Maaher
Messages: 7065
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

Report message to a moderator

Re: Drop Dual/User_objects [message #210937 is a reply to message #210920]

Sat, 23 December 2006 22:14

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

Report message to a moderator

Re: Drop Dual/User_objects [message #211095 is a reply to message #210922]

Tue, 26 December 2006 05:39

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.

Report message to a moderator

Re: Drop Dual/User_objects [message #211100 is a reply to message #211095]

Tue, 26 December 2006 06:16

Mahesh Rajendran
Messages: 10708
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'.

Report message to a moderator

Previous Topic:	Urgent help need .... backup/restore with RMAN from another host ...
Next Topic:	How to set a cronjob

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 17 07:17:52 CST 2026