And for versions 8.1 and earlier you could just say: set pagesize 0 spool backup.lst select text from dba_source where owner =3D 'SCHEMA_OWNER' order by name, type, line ; But in general the in-house written source code was put in a source = control system, and the third-party source code would be retrieved from = a database backup if necessary. I would share with the complaining DBA in your group the mantra I repeat = to myself now that I'm learning SQL Server basics (from Thomas Kyte's = book): understand your database, know how it works, know what it can do = for you, and use it to its fullest potential. My corollary - don't = complain about what the database doesn't do, but look for the things = that it does well. > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Freeman, Donald > Sent: jeudi, 12. f=E9vrier 2004 12:53 > To: oracle-l@xxxxxxxxxxxxx > Subject: RE: Export/backup Stored Database Procedures >=20 >=20 > If you are at 9i above you can use: >=20 > SELECT =20 > DBMS_METADATA.GET_DDL('PROCEDURE',a.object_name,a.owner) FROM =3D > dba_objects a > WHERE OWNER =3D3D'SCHEMA_OWNER' > AND object_TYPE =3D3D'PROCEDURE' > ORDER BY owner > / >=20 > -----Original Message----- > Michael Fontana >=20 > What methods do most on this list use to back up stored database > procedures? >=20 > I am familiar with exporting the SYS user only, and importing=20 > 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". >=20 > 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. ---------------------------------------------------------------- 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 -----------------------------------------------------------------