Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: [Q] backup triggers and/or stored procedures

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

From: Winston Douglas <wdouglas_at_cott.com>
Date: 1997/04/25
Message-ID: <01bc51b7$8bfb52a0$0e3210ac@winston.cott.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US