Home » RDBMS Server » Backup & Recovery » Recover the old snapshot of view.
Recover the old snapshot of view. [message #304573] Wed, 05 March 2008 12:48 Go to next message
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.
Re: Recover the old snapshot of view. [message #304574 is a reply to message #304573] Wed, 05 March 2008 12:51 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: Recover the old snapshot of view. [message #304578 is a reply to message #304574] Wed, 05 March 2008 13:05 Go to previous messageGo to next message
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.
Re: Recover the old snapshot of view. [message #304579 is a reply to message #304578] Wed, 05 March 2008 13:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use indexfile parameter and extract the view definition from generated file.

Regards
Michel
Re: Recover the old snapshot of view. [message #304583 is a reply to message #304579] Wed, 05 March 2008 13:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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


Re: Recover the old snapshot of view. [message #304585 is a reply to message #304583] Wed, 05 March 2008 13:31 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You might be right. Wink

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


Current Time: Sun Dec 04 06:37:51 CST 2016

Total time taken to generate the page: 0.07432 seconds