OraFAQ Forum: Backup & Recovery » Recover a table from oracle 8i archive log mode urgent

Home » RDBMS Server » Backup & Recovery » Recover a table from oracle 8i archive log mode urgent

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

Recover a table from oracle 8i archive log mode urgent [message #132753]

Tue, 16 August 2005 00:43

reyazan
Messages: 53
Registered: February 2005

Member

i am using the oracle8i enterprise edition on windows 2000 server.and database is on archivelog mode.
i have drop a table ,Now
i want to Know how i recover that table

please help

Report message to a moderator

Re: Recover a table from oracle 8i archive log mode urgent [message #132757 is a reply to message #132753]

Tue, 16 August 2005 00:55

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Hi,

You cannot just restore a table. You need to:

1. Restore a backup on a different machine
2. Export the table
3. Import the table into the original database

Oracle 10g users can just un-drop tables from the recycle bin.

Best regards.

Frank

Report message to a moderator

Previous Topic:	cold backup with RMAN
Next Topic:	Urgent -Formated windows and need to restore

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 22:37:42 CDT 2024