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
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))
