SQL loaderの備忘録 ■■■create table■■■ create table LoadedTable( ColA char(6), ColB char(9), ColC number(30), ColD number(30)) ■■■制御ファイル■■■ Load Data Infile 'C:\work\work.txt' Into table LoadedTable TRUNCATE fields terminated by ',' optionally enclosed by '"' (ColA,ColB,ColC,ColD) ■■■データファイル■■■ "ABCDEF","111111111","123456",000000111111 "GHIJKL","222222222","123456",000000222222 "MNOPQR","333333333","123456",000000333333 ■■■DOSコマンド■■■ sqlldr scott/tiger@Name control=C:\work\work.ctl log=C:\work\sqlldrLog.log
exp/impの備忘録 exp SCOTT/TIGER FILE=C:\expimp\20080220dmp.dmp OWNER=SCOTT CONSISTENT=Y LOG=C:\expimp\expLog.txt imp SCOTT/TIGER FILE=C:\expimp\20080220dmp.dmp FROMUSER=SCOTT TOUSER=SCOTT LOG=C:\expimp\impLog.txt
expdp/impdpの備忘録 expdp test/test DIRECTORY=DATAPUMP DUMPFILE=test20080225.dmp SCHEMAS=Test impdp test/test DIRECTORY=DATAPUMP DUMPFILE=test20080225.dmp remap_schema=test:test2