Home » SQL & PL/SQL » SQL & PL/SQL » How to get back deleted procedure from package
How to get back deleted procedure from package [message #243465] Thu, 07 June 2007 06:39 Go to next message
ShivrajGutte
Messages: 21
Registered: April 2007
Location: PUNE
Junior Member
In case, i have deleted one proc. from package and compiled the package . Is there any way to get back that deleted Procedure.

Thanks

Regards
Shiv
Re: How to get back deleted procedure from package [message #243473 is a reply to message #243465] Thu, 07 June 2007 07:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle version?

There is no simple way but you have the source somewhere in your files, hasn't it.

Regards
Michel
Re: How to get back deleted procedure from package [message #243476 is a reply to message #243473] Thu, 07 June 2007 07:45 Go to previous messageGo to next message
ShivrajGutte
Messages: 21
Registered: April 2007
Location: PUNE
Junior Member
9i
Re: How to get back deleted procedure from package [message #243481 is a reply to message #243476] Thu, 07 June 2007 08:12 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Some options:
Restore a backup
If your project is a serious project, you have it in a source-version repository
Get it from another environment (dev/test/prod)
Previous Topic: default length
Next Topic: How to refresh Materialized view in oracle version 9.2.0.5 64 bit
Goto Forum:
  


Current Time: Sun Dec 04 08:54:36 CST 2016

Total time taken to generate the page: 0.04315 seconds