Re: Export/backup Stored Database Procedures
- From: "Ryan" <ryan.gaffuri@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 12 Feb 2002 23:09:17 -0500
I have a package that I 'think' works, that writes stored code, etc... to a
file in the proper order to ensure dependencies. We need it for our data
loads. Its really ugly and I never trust code this nasty... if you want it
send me a private email. It uses a korn shell script to run it.(strictly due
to our architecture). The package 'exports' one user at a time and assumes
that all dependencies are with in the same user.
In my opinion the best way to backup code, is through a change management
process. Where you 'check in' and 'check out' code by version.
if you want it, send the email to rkgaffuri@xxxxxxx (I get too many emails
at this one).
----- Original Message -----
From: "Arup Nanda" <orarup@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, February 12, 2004 10:59 PM
Subject: Re: Export/backup Stored Database Procedures
> Or, if you are on Oracle 10g, you could use Data Pump Export to export at
> any granular level, including any specific names.
>
>
> ----- Original Message -----
> From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> Sent: Thursday, February 12, 2004 3:53 PM
> Subject: RE: Export/backup Stored Database Procedures
>
>
> > If you are at 9i above you can use:
> >
> > SELECT DBMS_METADATA.GET_DDL('PROCEDURE',a.object_name,a.owner) FROM =
> > dba_objects a
> > WHERE OWNER =3D'SCHEMA_OWNER'
> > AND object_TYPE =3D'PROCEDURE'
> > ORDER BY owner
> > /
> >
> > -----Original Message-----
> > From: oracle-l-bounce@xxxxxxxxxxxxx
> > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Michael Fontana
> > Sent: Thursday, February 12, 2004 2:40 PM
> > To: oracle-l@xxxxxxxxxxxxx
> > Subject: Export/backup Stored Database Procedures
> >
> >
> >
> > 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.
> >
> >
> >
> > Michael Fontana
> > Sr. DBA
> > NTT/Verio
> >
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
