OraFAQ Forum: Backup & Recovery » Restoring 1 Table

Home » RDBMS Server » Backup & Recovery » Restoring 1 Table

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

Restoring 1 Table [message #109165]

Tue, 22 February 2005 12:31

Eudoro
Messages: 7
Registered: January 2003

Junior Member

I have been trying to figure out a way to restore just 1 table from a RMAN backup set. Is there a way to do this besides restoring the data to a different tablespace and moving the table?

Thanks,
Eudoro

Report message to a moderator

Re: Restoring 1 Table [message #109240 is a reply to message #109165]

Wed, 23 February 2005 02:53

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi,

no, the only qay to get only one table will be an export / import.
rman's lowest will be tablespace .....

so far I know.

Report message to a moderator

Re: Restoring 1 Table [message #109325 is a reply to message #109165]

Wed, 23 February 2005 16:47

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

This is not a direct answer to your question.
Just wanted point that, it is possible with 10g (flash back database).

Report message to a moderator

Re: Restoring 1 Table [message #109365 is a reply to message #109165]

Thu, 24 February 2005 03:06

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

okay, Mahesh - thats right.
10g also uses the "Trash-Bin" function, but up to 9i there is no way, I guess

Uwe

Report message to a moderator

Previous Topic:	Starting Oracle 8.0.5.22 in HP-UX 11.11
Next Topic:	Can I attach a cold backup of one instance to another instance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 05:04:52 CDT 2024