oracle 为11g,报以下错误:
ORA-29913: 执行 ODCIEXTTABLEOPEN 调出时出错
ORA-29400: 数据插件错误KUP-04043: table column not found in external source: ID
开始创建的sql为在网上查找到:
外部表的参数部分为下面:
RECORDS DELIMITED BY NEWLINE CHARACTERSET ZHS16GBK
SKIP 10
BADFILE 'DATA_LOG_PATH':'table1.bad'
NODISCARDFILE
LOGFILE 'DATA_LOG_PATH':'table1.log'
READSIZE 1048576
FIELDS LDRTRIM
REJECT ROWS WITH ALL NULL FIELDS
(
"id" (1,4) char(4) nullif ("id" = blanks),
"name" (5,24) char(20) nullif ("name" = blanks)
)
)
按照这种创建外部表后,报错所以进行修改如下:
--