|
Administrator
|
You are asking about PLSQL Packages I guess. (a package right...) This is a very general question.
You can do it by following your own procedures, just get them into text files and save them in a secure fault tolerant place.
You can also directly get the codes (as text) using db internal views, like dba_source.
you can also use versioning tools like SVN to support your PLSQL development, deployment activities.
Remember that, these actions (drop, restore, recreate etc..) will bring invalid objects (due to dependencies) into your env, you need to recompile them.. So you need to follow your own case-based procedures while playing with the PLSQL objects.
|
Locked
