Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: [Q] backup triggers and/or stored procedures
You can export the database without data using the export tool "exp" with the parameter "rows=n". Then import the file using the import utility "imp" with the parameters "show=y" and "log=<your log file name>".
The disadvantage is the log file created will contain the scripts for all the objects in the database or for the schema specified. Received on Fri Apr 25 1997 - 00:00:00 CDT