On 02/12/2004 02:40:20 PM, Michael Fontana wrote:
>
> What methods do most on this list use to back up stored database
> procedures?
>
> I am familiar with exporting the SYS user only, and importing to
> another
> staging database, and pulling the source code out of there, but I
> must
> admit, this involves several steps and is a relative "kludge".
>
> A DBA in our group, with Sybase and SQLServer experience, complains
> because Oracle does not have a method to single out such objects for
> backup.
Well, hopefully, you are backing up your database. As for the stored
procedures, they're called "stored" because they're stored in the
database. Consequently, when you back up your database, you back up
your stored procedures as well. Also, it is beneficial that duhvelopers
who duhveleped them have them stored in CVS, RCS, SCCS or something
similar. In addition to that, you should backup all files
and subdirectories from the directory that PLSQL_NATIVE_LIBRARY_DIR
parameter points to. That is particularly important if your parameter
PLSQL_CODE_TYPE is set to "NATIVE".
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Feb 12 2004 - 15:22:05 CST
