<<Back to Oracle DATAPUMP Main Page
How to Export Tablespace using expdp
TABLESPACES=<comma seprated list of tablespace>$ cat exp.par
DIRECTORY=EXP
DUMPFILE=EXP.DMP
LOGFILE=EXP.LOG
TABLESPACES=TEST
REUSE_DUMPFILES=Y
FLASHBACK_TIME=SYSTIMESTAMP
$ expdp test@PDB01 parfile=exp.par
How to Import Individual Tablespace using impdp
$ cat imp.parDIRECTORY=EXP
DUMPFILE=EXP.DMP
LOGFILE=IMP.LOG
TABLESPACES=TEST
$impdp system@PDB02 parfile=imp.par
During the following import situations, Data Pump automatically creates the tablespaces into which the data will be imported:
• The import is being done in FULL or TRANSPORT_TABLESPACES mode
• The import is being done in table mode with TRANSPORTABLE=ALWAYS
In all other cases, the tablespaces for the selected objects must already exist.
Comments
Post a Comment