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

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. Retrieve all your triggers/procedures from table USER_OBJECTS select object_name from user_objects where objetc_type = 'TRIGGER';

afterwards you can fetch all source lines from USER_SOURCES. Received on Sat Apr 26 1997 - 00:00:00 CDT