※SQLに"PAPER_T/PAPER_T@ASPAC"でログインして実行(PAPERに権限を付与する為にPAPER_Tでログインすること）

■ディレクトリ・オブジェクトの確認
# set pagesize 0;
# select * from dba_directories;



;ジュラロン_ﾃﾞｨﾚｸﾄﾘ作成
sqlplus system/manager@ASPK
create or replace directory EXP_DIR as 'C:\AS_KAIKEI\expdp';
grant read, write on directory EXP_DIR to JUR;
exit;


;カワサキ_ﾃﾞｨﾚｸﾄﾘ作成
sqlplus system/manager@ASPK
create or replace directory EXP_DIR as 'C:\AS_KAIKEI\expdp';
grant read, write on directory EXP_DIR to KWS;
exit;


;オプナスCOM
sqlplus system/manager@ASPK
create or replace directory EXP_DIR as 'C:\AS_KAIKEI\expdp';
grant read, write on directory EXP_DIR to COM;
exit;


;オプナスDAT0001
sqlplus system/manager@ASPK
create or replace directory EXP_DIR as 'C:\AS_KAIKEI\expdp';
grant read, write on directory EXP_DIR to DAT0001;
exit;

;オプナスMST0001
sqlplus system/manager@ASPK
create or replace directory EXP_DIR as 'C:\AS_KAIKEI\expdp';
grant read, write on directory EXP_DIR to MST0001;
exit;

;オプナスTRNH0001069
sqlplus system/manager@ASPK
create or replace directory EXP_DIR as 'C:\AS_KAIKEI\expdp';
grant read, write on directory EXP_DIR to TRNH0001069;
exit;

;オプナスTRNH0001068
sqlplus system/manager@ASPK
create or replace directory EXP_DIR as 'C:\AS_KAIKEI\expdp';
grant read, write on directory EXP_DIR to TRNH0001068;
exit;






;トーフレ_ﾃﾞｨﾚｸﾄﾘ作成
sqlplus system/manager@ASPK
create or replace directory EXP_DIR as 'C:\AS_KAIKEI\expdp';
grant read, write on directory EXP_DIR to TFL;
exit;





※DOSプロンプトよりexpdpを実行


▼ジュラロン工業
expdp JUR/JUR@EPMSCM directory=EXP_DIR dumpfile=JUR_KAIKEI2.dump logfile=JUR_KAIKEI2.log schemas=JUR VERSION=11.2
impdp JUR/JUR@ASPK directory=EXP_DIR dumpfile=JUR_EXPDP.DMP logfile=JUR_EXPDP.log tables=(JURMENUN2,JUR0001000%,JURC%,JURP%,JUR0001060%,JUR0001059%)

▼カワサキ
expdp KWS/KWS@ASPK directory=EXP_DIR dumpfile=KWS_EXPDP.dmp logfile=KWS_EXPDP.log tables=(KWS0001045%) VERSION=11.2
impdp KWS/KWS@ASPK directory=EXP_DIR dumpfile=KWS_EXPDP.dmp schemas=KWS VERSION=11.2


▼オプナスDAT0001
impdp COM/COM@ASPK directory=EXP_DIR dumpfile=COM_EXPDP.DMP
impdp DAT0001/DAT0001@ASPK directory=EXP_DIR dumpfile=DAT0001_EXPDP.DMP
impdp MST0001/MST0001@ASPK directory=EXP_DIR dumpfile=MST0001_EXPDP.DMP
impdp TRNH0001069/TRNH0001069@ASPK directory=EXP_DIR dumpfile=TRNH0001069_EXPDP.DMP
impdp TRNH0001068/TRNH0001068@ASPK directory=EXP_DIR dumpfile=TRNH0001068_EXPDP.DMP


▼トーフレ
;EXPDPｺﾏﾝﾄﾞ
expdp TFL/TFL@ASPK directory=EXP_DIR dumpfile=TFL_expdp_20180109.dmp logfile=TFL_expdp_20180109.log schemas=TFL VERSION=11.2

;IMPDPｺﾏﾝﾄﾞ
impdp TFL/TFL@ASPK directory=EXP_DIR dumpfile=TFL_expdp.dmp logfile=TFL_expdp_20180122.log schemas=TFL VERSION=11.2





▼日本ストロー_ﾃﾞｨﾚｸﾄﾘ作成
sqlplus system/manager@EPMSCM
create or replace directory EXP_DIR as 'E:\AS_KAIKEI\ASPK_NPS\expdp';
grant read, write on directory EXP_DIR to NPSK;
exit;


expdp NPSK/NPSK@EPMSCM directory=EXP_DIR dumpfile=NPS_expdp.dmp logfile=NPS_expdp.log schemas=NPSK VERSION=11.2