OraFAQ Forum: Server Administration » How to retrieve the dropped table

Home » RDBMS Server » Server Administration » How to retrieve the dropped table

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

How to retrieve the dropped table [message #182978]

Wed, 19 July 2006 01:21

sreehari
Messages: 101
Registered: May 2006

Senior Member

Hi all

Is there any way of retrieving the dropped table

Thanks

Report message to a moderator

Re: How to retrieve the dropped table [message #183028 is a reply to message #182978]

Wed, 19 July 2006 04:06

aciolac
Messages: 242
Registered: February 2006

Senior Member

If your database in NOARCHIVELOG mode, then there are no one posibility. If in ARCHIVELOG, then:
1)You can recover database until time, when you are dropped table, export dropped table, recover database till the current time, and import table.
2)You can use logminer. See docs about.

Report message to a moderator

Re: How to retrieve the dropped table [message #183035 is a reply to message #183028]

Wed, 19 July 2006 04:22

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If your Oracle database version supports it, you could try to restore the table from the Recycle Bin using Flashback. Check this document (with an example).

Report message to a moderator

Previous Topic:	Regarding Extent Allocation
Next Topic:	Creating Second Database and viewing through EM.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:40:47 CDT 2024