gbvy[Wɖ߂    ̓m    O̓m

m12 sqlldrexp/impexpdp/impdp


SQL loader̔Y^ create table create table LoadedTable( ColA char(6), ColB char(9), ColC number(30), ColD number(30)) t@C Load Data Infile 'C:\work\work.txt' Into table LoadedTable TRUNCATE fields terminated by ',' optionally enclosed by '"' (ColA,ColB,ColC,ColD) f[^t@C "ABCDEF","111111111","123456",000000111111 "GHIJKL","222222222","123456",000000222222 "MNOPQR","333333333","123456",000000333333 DOSR}h sqlldr scott/tiger@Name control=C:\work\work.ctl log=C:\work\sqlldrLog.log
exp/imp̔Y^ 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̔Y^ expdp test/test DIRECTORY=DATAPUMP DUMPFILE=test20080225.dmp SCHEMAS=Test impdp test/test DIRECTORY=DATAPUMP DUMPFILE=test20080225.dmp remap_schema=test:test2