Oracle expdp/impdp parameter files example

posted Dec 20, 2011, 7:07 PM by Sachchida Ojha   [ updated Dec 21, 2011, 8:31 AM ]
1. hr.par
SCHEMAS=HR
DUMPFILE=exp.dmp
DIRECTORY=dpump_dir1
LOGFILE=exp.log
 
2. Import but exclude certain views
DIRECTORY=TEST_DUMP_DIR
DUMPFILE=TEST_DUMP_DIR:DBAREF_2011101234563_%UA%U
LOGFILE=IMPDP20111012170157.log
JOB_NAME=IMPDP20111012170157
EXCLUDE=VIEW:"LIKE \'MJB%\'"
PARALLEL=4
REMAP_SCHEMA=DBAREF1:DBAREF2

3. Import table partition partitions PART_TAB:PART_1
DIRECTORY=TEST_DUMP_DIR
DUMPFILE=TEST_DUMP_DIR:DBAREF_20111201160721_%UA%U
LOGFILE=IMPDP_etl_Partition_test.log
JOB_NAME=IMPDP_etl_Partition_test_1
TABLES=DBAREF1.PART_TAB:PART_1
REMAP_SCHEMA=DBAREF1:DBAREF2
TABLE_EXISTS_ACTION=APPEND
 
4.Import STAT table
DIRECTORY=TEST_DUMP_DIR
DUMPFILE=TEST_DUMP_DIR:DBAREF_20110916084709_%UA%U
LOGFILE=impdpSTATS_ONLY.log
JOB_NAME=STATS_ONLY
TABLES=DPUMP_DB_SCMA_STATS
REMAP_SCHEMA=DBAREF1:DBAREF2
 
5. Export Table only
DIRECTORY=TEST_DUMP_DIR
DUMPFILE=TEST_DUMP_DIR:DBAREF_20112122_%UA%U
LOGFILE=expdpDBAREF_20112122.log
JOB_NAME=EXPDP20112122
PARALLEL=2
TABLES=tab1,tab2
COMPRESSION=ALL
 
6.import  data only for list of tables
DIRECTORY=TEST_DUMP_DIR
DUMPFILE=TEST_DUMP_DIR:DBAREF_2011123456_%UA%U
LOGFILE=IMPDP2011123456.log
JOB_NAME=IMPDP2011123456
CONTENT=DATA_ONLY
INCLUDE=TABLE:"IN(SELECT tbl_nme FROM DBAREF1.tab3 WHERE 1=2)"
REMAP_SCHEMA=DBAREF1:DBAREF2
Comments