OraFAQ Forum: Server Administration » Help: User dropped table, what do I do?

Home » RDBMS Server » Server Administration » Help: User dropped table, what do I do?

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

Help: User dropped table, what do I do? [message #52459]

Tue, 23 July 2002 07:37

John Smith
Messages: 25
Registered: February 2002

Junior Member

I am a new oracle dba. One of my users has accidentially dropped an entire table with data. What do I do?

Report message to a moderator

Re: Help: User dropped table, what do I do? [message #52460 is a reply to message #52459]

Tue, 23 July 2002 07:52

Grant
Messages: 578
Registered: January 2002

Senior Member

What type of backups do you run? What version of Oracle are you running?

Report message to a moderator

Re: Help: User dropped table, what do I do? [message #52466 is a reply to message #52459]

Wed, 24 July 2002 10:48

David Simpson
Messages: 29
Registered: May 2002

Junior Member

If you have an recent export of the database, you can attempt to re-import the dropped table. The following URL provides an example of this situation in Recovery Scenario #8:

http://www.dotcomsolutionsinc.net/products/installgen/sol_901_32bit_files/installgen_sol901_39_.html#recovery_scenarios

David Simpson
www.dotcomsolutionsinc.net

15 Oracle Database Recovery Scenarios

Report message to a moderator

Re: Help: User dropped table, what do I do? [message #52579 is a reply to message #52460]

Tue, 30 July 2002 11:24

John Smith
Messages: 25
Registered: February 2002

Junior Member

I'm using oracle 9i and well I don't know exactly what backups I have. I was wondering if you could give me all the different scenarios that are possible.

Report message to a moderator

Re: Help: User dropped table, what do I do? [message #52581 is a reply to message #52460]

Tue, 30 July 2002 11:34

John Smith
Messages: 25
Registered: February 2002

Junior Member

I'm using oracle 9i and well I don't know exactly what backups I have. I was wondering if you could give me all the different scenarios that are possible.

Report message to a moderator

Previous Topic:	ORA-00600[4097] error code
Next Topic:	ORA-00600: internal error code, arguments: [4512],

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:25:19 CDT 2024