expdp/impdp实例
2019-03-12expdp也可以直接导入远程的数据到本地.
1、expdp userid=dbmgr/paic1234
directory=ttimp_dir
parallel=4
tables=
(
GBSMAN.GPO_PRD_SETT_MAIN
)
content=all
network_link=lin_cowgbs
LOGFILE=ttimp_gbs1.log
JOB_NAME=ttjob_gbs1
REMAP_SCHEMA=gbsman:aud_gbs
REMAP_TABLESPACE=gbs:ludata
TABLE_EXISTS_ACTION=REPLACE
EXCLUDE=constraint, ref_constraint, grant,index,trigger
2、有些表包含长列不支持
ORA-31679: Table data object "TALK99_CMS"."MSITE_FILE" has long columns, and longs can not be loaded/unloaded using a network link
expdp导出到本地，然后scp传输到目标机，然后再impdp导入
MSITE_FILE
TOAD_PLAN_TABLE
3、impdb实例
#TABLE_EXISTS_ACTION=SKIP /APPEND/ TRUNCATE/ REPLACE(first drop)
impdp 'aaa/success' DIRECTORY=expdp_dir1 parallel=2 TABLE_EXISTS_ACTION=REPLACE \
dumpfile=$file logfile=impdp_lyyg_${today}.log REMAP_SCHEMA=T1_CMS:T2_LYYG REMAP_TABLESPACE=T1_OTHER_TS:T2_LYYG_TS,T1_CRM_TS:T2_LYYG_TS \
INCLUDE=TRIGGER
#TABLES=MALL_BUYERS,ITVER_USER_DEAL