数据泵执行导入导出

1. oracle expdp区分大小写
2. expdp的directory指定的目录必须存在,否则会报ORA-39070: Unable to open the log file.因为oracle在创建目录时并不检查目录是否存在
3. 如果expdp转储的dump文件已经存在回报错
4. 在expdp的par文件中不需要再定义操作系统转义字符,否则会出错

5. 在命令行中,不能使用单引号,而用双引号引入query子句内容

6.在执行导入时可以指定query和parallel参数

impdp rudy/jume123456@asm_redhat01 tables=customer_info dumpfile=customer_info%u.dmp  logfile=customer_info%u.log directory=TEST_DIR table_exists_action=append  parallel=4

EXP rudy/jume123456@asm_redhat01   BUFFER=64000 FILE=e:\test_rudy.DMP  direct=y

IMP  rudy/jume123456@asm_redhat01    BUFFER=64000  FILE=e:\test_rudy.DMP log=e:\test_rudy.log  FROMUSER=rudy  TOUSER=wcs_s tables=TEMP_CUSTOMER_INFO grants=n indexes=n analyze=n

sqlldr rudy/jume123456@asm_redhat01 control=e:\temp_customer.ctl log=e:\temp_customer.log bad=e:\temp_customer.bat rows=640 direct=true bindsize=10485760

expdp rudy/jume123456@asm_redhat01 tables=customer_info dumpfile=customer_info%u.dmp logfile=customer_info%u.log directory=TEST_DIR filesize=500m parallel=4

csv控制文件

load data
infile 'E:\LABAC_ACCOUNT_COUPONS.csv'
append into table LABAC_ACCOUNT_COUPONS
fields terminated by ',' 
(COUPON_SEQ_ID,COUPON_CARD_ID,COUPON_TYPE_ID FILLER,COUPON_START_DATE DATE "YYYY-MM-DD HH24:MI:SS",COUPON_END_DATE DATE "YYYY-MM-DD HH24:MI:SS",COUPON_ENABLE_FLAG)

导入json控制文件

load data
infile 'E:\temp_assignment_body.txt'
append into table temp_assignment_body
fields terminated by X'09' 
(assignment_id,assignment_response_body char(4000))