Oracle DB Import DataDump (impdp) Parameters and Import Types
Different ways of Oracle DB Import DataDump
* IMPORT Full Schema DUMP – Single File Dump
Impdp username/Password@dbname
dumpfile=Single_dump_file.dmp
SCHEMAS=schema_name
directory=DATA_PUMP_DIR
logfile=log_file_name.log
* IMPORT Full Schema DUMP – Multiple File Dump
Impdp username/Password@dbname
dumpfile=file_name_%U.dmp
SCHEMAS=schema_name
directory=DATA_PUMP_DIR
logfile=log_file_name.log
* IMPORT FULL DUMP – Schema Name Change
impdp username/Password@dbname
dumpfile=dump_file_name.dmp
SCHEMAS=schemaname
REMAP_SCHEMA=Source_Schema:Target_Schema
directory=DATA_PUMP_DIR
logfile=log_file_name.log
parallel=4
filesize=1G
* IMPORT Full Schema DUMP – Tablespace Name Change
Impdp username/Password@dbname
SCHEMAS=schema_name
REMAP_TABLESPACE=source_tablespace:target_tablespace
dumpfile=file_name.dmp
directory=DATA_PUMP_DIR
logfile=log_file_name.log
* IMPORT DUMP — Only Tables
Impdp username/Password@dbname
dumpfile=file_name.dmp
TABLES=Table_name
directory=DATA_PUMP_DIR
logfile=logfilename.log
* IMPORT using SYSDBA User
Import using the “SYSDBA” user instead of using the specific user/pwd, use the below syntex :
impdp \”/ as sysdba\”
dumpfile=dump_file_%u.dmp
SCHEMAS=Schema_Name
directory=DATA_PUMP_DIR
logfile=log_filename_1.log
metrics=Y
parallel=8
filesize=1G