Need Backup of Objects [message #627505] |
Wed, 12 November 2014 08:04 |
|
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 |
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.
|
|
|