oracledba.help
DataPump

Export\Import: Table

Destination Database Prerequisites

  1. Is taking the database out of ArchiveLogMode temporarily to improve import speed warranted?
    Otherwise consider using: TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
  2. All the tablespaces the user(s) access exist.
    Though they would be recreated in the import, it is better to pre-create with the ideal location and size.
  3. All user tablespaces are sized adequately.
    You can use ts.createResizeCmds.sql
  4. The users Temporary tablespace exists and is large enough.
  5. All apps and processes on the destination schema have been stopped.
  6. Kill any user sessions that may access schema to be refreshed.

Command Line

Export

expdp username/password 
   DIRECTORY=dir_obj 
   DUMPFILE=dump_file_name
   JOB_NAME=job_name 
   TABLES=comma_delimited_list_of_tables_to_export
   [COMPRESSION=type] 
expdp system/password DUMPFILE=hr_tables.dmp DIRECTORY=datapump 
   JOB_NAME=xTables LOGFILE=xTables.log
   TABLES=hr.locations,hr.employee 

Import

impdp username/password 
   DIRECTORY=dir_obj 
   DUMPFILE=dump_file_name
   JOB_NAME=job_name 
   TABLES=list_of_tables_to_import
impdp system/password DUMPFILE=hr_tables.dmp DIRECTORY=datapump 
   JOB_NAME=impTables LOGFILE=impTables.log
   TABLES=hr.locations,hr.employee 

Parameter File (.par)

Export

# expdp system/password PARFILE=exportTables.par
COMPRESSION=ALL
DIRECTORY=datapump
DUMPFILE=hr_tables.dmp
JOB_NAME=xTables
LOGFILE=xTables.log
TABLES=hr.locations,hr.employee

Import

# impdp system/password PARFILE=importTables.par
DIRECTORY=datapump
DUMPFILE=hr_tables.dmp
JOB_NAME=impTables
LOGFILE=impTables.log
TABLES=hr.locations,hr.employee
TABLE_EXISTS_ACTION=replace

<- DataPump