Oracle DB Export DataDump (expdp) Parameters and Export Types
Different ways of Oracle DB Export DataDump
* EXPORT – FULL DUMP (Full = Y) – Single Dump File
expdp username/[email protected]
dumpfile=dump_file_name.dmp
FULL=Y
directory=DATA_PUMP_DIR
logfile=log_file_name.log
parallel=4
filesize=4G
* EXPORT – FULL DUMP – with Flashback SCN Number
expdp username/[email protected]
dumpfile=dump_file_name.dmp
FULL=Y
directory=DATA_PUMP_DIR
logfile=log_file_name.log
parallel=4
filesize=4G
FLASHBACK_SCN=12323232
* EXPORT – FULL DUMP (Full = Y) with Multiple Dump Files
expdp username/[email protected]
dumpfile=dump_file_name_%U.dmp
FULL=Y
directory=DATA_PUMP_DIR
logfile=log_file_name.log
parallel=4
filesize=4G
* EXPORT DUMP — Tables only
expdp username/[email protected]
dumpfile=dump_file_name.dmp
tables=schema1.table1, schema2.table2
directory=DATA_PUMP_DIR
logfile=log_file_name.log
* EXPORT DUMP – METADATA_ONLY
expdp username/[email protected]
dumpfile=dump_file_name.dmp
SCHEMAS=schemaname
CONTENT=METADATA_ONLY
directory=DATA_PUMP_DIR
logfile=log_file_name.log
parallel=4
* EXPORT FULL DUMP – TIME LOGS & METRICS
expdp username/[email protected]
dumpfile=dump_file_name.dmp
SCHEMAS=schemaname
directory=DATA_PUMP_DIR
logfile=log_file_name.log
LOGTIME =ALL
METRICS=Y
*EXPORT FULL DUMP using SYSDBA User
Export using the “SYSDBA” user instead of using the specific user/pwd, use the below syntex :
expdp \”/ as sysdba\”
dumpfile=dump_file_%u.dmp
SCHEMAS=Schema_Name
directory=DATA_PUMP_DIR
logfile=log_filename_1.log
metrics=Y
parallel=8