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: exp/imp Oracle 7.3

Re: exp/imp Oracle 7.3

From: MMK Productions <nospam.mmkprod_at_bellatlantic.net>
Date: Wed, 24 Jun 1998 22:31:22 -0400
Message-ID: <6msct9$e6t@world6.bellatlantic.net>


You might want to use a parameter file to include the export/import parameters. This is an ASCII file with the parameters on each line.

Here is an example for your question:

# filename: db1fulexp.par
userid=system/manager
log=db1fulexp.log
file=/dir1/exports/db1fulexp.dmp
full=y
buffer=500000
indexes=y
rows=y
grants=y
compress=y
<the line above was the last line of the file>

You can use a similar file for imports
# filename: db1fulimp.par
userid=system/manager
log=db1fulimp.log
file=/dir1/exports/db1fulexp.dmp
full=y

commit=y
buffer=500000
ignore=y

<the line above was the last line of the file>
Received on Wed Jun 24 1998 - 21:31:22 CDT

Original text of this message

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