Home » SQL & PL/SQL » SQL & PL/SQL » Need Backup of Objects (11g)
Need Backup of Objects [message #627505] Wed, 12 November 2014 08:04 Go to next message
AsthanaP
Messages: 1
Registered: November 2014
Location: India
Junior Member
All,

I recently facing some problem when ever i execute some object script on any enviorment for testing old script for that object is overwrite.

Is there any way to backup the object which is going to drop/alter before the operation.

Thanks in advance

Pratik Asthana
Re: Need Backup of Objects [message #627507 is a reply to message #627505] Wed, 12 November 2014 08:08 Go to previous message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
Well most DB GUIs will let you save DB objects to file, and you can use dbms_metadata to create a script of the object. But really this question shouldn't normally come up since you should already have the previous version saved and in source control.
Previous Topic: Handling Big String
Next Topic: sql
Goto Forum:
  


Current Time: Fri Apr 26 10:08:07 CDT 2024