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