OraFAQ Forum: Backup & Recovery » Recover the old snapshot of view.

Home » RDBMS Server » Backup & Recovery » Recover the old snapshot of view.

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

Recover the old snapshot of view. [message #304573]

Wed, 05 March 2008 12:48

arksjd
Messages: 13
Registered: November 2007

Junior Member

Hi..

I was working on a view v1. But accidentally I compiled another view with the same name v1. Now I have lost the code of the original view.

How can I recover the view definition of my orginal view v1.

Kindly help.

Thanks.

Report message to a moderator

Re: Recover the old snapshot of view. [message #304574 is a reply to message #304573]

Wed, 05 March 2008 12:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How can I recover the view definition of my orginal view v1.
By extract it from your source code control system or restoring from backups.

Report message to a moderator

Re: Recover the old snapshot of view. [message #304578 is a reply to message #304574]

Wed, 05 March 2008 13:05

arksjd
Messages: 13
Registered: November 2007

Junior Member

Hi

I have the export dump file...taken last week.
But kindly help me how to import only the view definitions from the export dump file.

Report message to a moderator

Re: Recover the old snapshot of view. [message #304579 is a reply to message #304578]

Wed, 05 March 2008 13:15

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use indexfile parameter and extract the view definition from generated file.

Regards
Michel

Report message to a moderator

Re: Recover the old snapshot of view. [message #304583 is a reply to message #304579]

Wed, 05 March 2008 13:22

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

Senior Member
Account Moderator

I ***believe*** , indexfile option may not show view contents (or at least as of 9i).
If it does not show, standard workaround is to use show=y log=somelogfile

Report message to a moderator

Re: Recover the old snapshot of view. [message #304585 is a reply to message #304583]

Wed, 05 March 2008 13:31

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You might be right. Wink

Regards
Michel

Report message to a moderator

Previous Topic:	Best way to backup a database
Next Topic:	Can Oracle10g RAM backup all objects of the user?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 01:39:09 CST 2024