| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Export/backup Stored Database Procedures
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_at_cox.net (I get too many emails at this one).
> 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_at_state.pa.us>
> To: <oracle-l_at_freelists.org>
> 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_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Michael Fontana
> > Sent: Thursday, February 12, 2004 2:40 PM
> > To: oracle-l_at_freelists.org
> > 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_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
> > -----------------------------------------------------------------
> > ----------------------------------------------------------------
> > 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
> > -----------------------------------------------------------------
> >
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
-- 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 - 22:09:25 CST
 |
 |