Oracle Export/Import

Bill Murray bmurray at snf.stanford.edu
Wed Apr 23 10:51:09 PDT 2003


Tom,

Here are the commands that I use to export and import Oracle data.  They
can be run directly from the command line.

exp SYSTEM/password PARFILE=export_params.dat

imp SYSTEM/password PARFILE=import_params.dat

where the parameter files are listed below.

atu [~/import] $ more export_params.dat 
BUFFER=4096
FILE=expdat.dmp
FULL=y
GRANTS=y
CONSISTENT=y
ROWS=y
COMPRESS=y
LOG=export.log

atu [~/import] $ more import_params.dat 
FILE=expdat.dmp
BUFFER=30720
IGNORE=y
GRANTS=y
INDEXES=y
ROWS=y
FULL=y
LOG=import.log


Bill





More information about the coral mailing list