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 DUMPTablespace 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


You may also like...