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

Georg Mey wrote:
>
> Another way to do a logical export can de done as follows:
>
> The table USER_SOURCES contains all source code lines of triggers and
> stored procedures. [...]

        No, actually USER_SOURCE contains only the code for stored procedures, functions, and packages. It would be nice if it did triggers as well, but it doesn't -- at least, not in 7.2 or earlier.

        You can create DDL that will build your triggers using commands like:

select 'create trigger ' || description,

	when_clause,
	trigger_body,
	'/'
	from user_triggers
	where trigger_name not like 'TLOG$_%'

but you have to make sure that the SQL*Plus LONG and LONGCHUNKSIZE are set large enough. You still may get improperly-wrapped lines that you will have to edit... but it's better than nothing.

-bn
neumebm_at_hpd.abbott.com Received on Tue Apr 29 1997 - 00:00:00 CDT