Destination Database Prerequisites
- Is taking the database out of ArchiveLogMode temporarily to improve import speed warranted?
Otherwise consider using: TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
- 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.
- All user tablespaces are sized adequately.
You can use ts.createResizeCmds.sql
- The users Temporary tablespace exists and is large enough.
- All apps and processes on the destination schema have been stopped.
- 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
