Re: [Q] backup triggers and/or stored procedures

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/04/26
Message-ID: <336276C6.3FB5@mf.sigov.mail.si>#1/1

Carlo Bartolomeo Martino wrote:

My server version is Oracle 7.2.3. I'm running under Solaris 2.5.

  How do I backup database triggers? Is this possible using no more   than
  the standard suite of utilities that come with Oracle? If not,   could
  anyone please recommend a comercial (preferably on the low side of   cost)
  or shareware package?
  .... <SNIP>.......

Source of your triggers and procedures/packages is stored in dictionary tables DBA/ALL/USER_TRIGGERS (triggers)
and DBA/ALL/USER_SOURCE (packages and procedures). So you can simply select appropriate fields (some of them are LONG or VARCHAR2(2000) from those tables and spool the result in a file.

Regards,

Jurij Modic
Ministry of Finance, Republic of Slovenia, Ljubljana Received on Sat Apr 26 1997 - 00:00:00 CDT