특정테이블만 datapump

--덤프

 

--데이터 익스포트

expdp sys/oracle dumpfile=data.dmp directory=dump logfile=data.log job_name=job_data network_link=ORA100 TABLES=TC_CMMN_D_CODE,TC_CMMN_M_CODE,TC_CMMN_QRANT_INSTT,TC_CMMN_RN_ADRES,TC_ENTRPS_UNITY,TN_CMMN_DBYHS_CL,TN_CMMN_DBYHS_CODE,TN_CMMN_ITM_PLNT_SE_CODE,TN_CMMN_LNM_RN_MTCHG,TN_CMMN_NATION_CODE,TN_CMMN_ITM_QUN_MAPNG,TN_CMMN_PRDLST,TN_CMMN_TRFCLSF,TN_CMMN_USER,TN_NPQ_REQST,TN_NPQ_REQST_DETAIL,TN_NPQ_RESULT,TN_NPQ_RESULT_DETAIL,RQISIT_STTUS,TN_LAB_FEE_ISPT_ITM_INFO,TN_LAB_FEE_PRDLST_ISPT_ITM,TN_LAB_FEE_PRDLST_ISPT_ITM_D,TC_CMMN_LMO_EVENT

 

--데이터 임포트

impdp sys/oracle directory=dump dumpfile=data.dmp  logfile=data.log TABLE_EXISTS_ACTION=REPLACE

 

-- 스키마 백업

expdp system/orclswindow dumpfile=test.dmp directory=dump schemas=test_schema job_name=job_test logfile=test_real.log

 

--스키마 impdp schemas

impdp system/orclswindow dumpfile=test.dmp directory=dump schemas=test_schema logfile=test.log job_name=test REMAP_TABLESPACE=REAL_TABLESPACE:TEST_TABLESPACE REMAP_SCHEMA=real_schema:test_schema TABLE_EXISTS_ACTION=REPLACE

 

--로컬에서 테스트 db_link

expdp sys/qlalfqjsgh dumpfile=data.dmp directory=dump logfile=test.log job_name=job_test network_link=ORA100 TABLES=TC_CMMN_D_CODE