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

I think the only way to do this is to do an export of the database using the "imp" utility without exporting the data (use parameter rows=n) and store the export file offline. If you want to store the text then you could then use the import utility "imp" to import the data with the parameters show=y and log=<some filename>. Then you can edit the log file to view the create statements for the triggers. The disadvantage of this is that the file will contain scripts for all the database objects including the triggers.

Carlo Bartolomeo Martino <martino_at_shell.inch.com> wrote in article <5jqnp7$37f$1_at_sleepy.inch.com>...
> 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?
>
> It'd be nice to be able to backup stored procedures and functions as
 well,
> but this isn't really necessary, as we keep copies of these in a library
> stored on our micros.
>
> Needless to say, advice or assistance of any sort would be greatly
> appreciated.
>
> Thanking you in advance,
>
> Carlo
>
> --
> Carlo Martino
> Avalanche Systems, Inc.
> New York City
>
> "With Yoga power, skate and snowboard tricks become easy."
> - A. Wong
>
>
>
Received on Fri Apr 25 1997 - 00:00:00 CDT