Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: exp/imp Oracle 7.3
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