物理表WAP_SPHTTP已经创建
下面贴出我的外部表文件(http.sql)内容如下:
set timing on;
create or replace directory DATA_PATH as 'F:\\test\\' ;
create or replace directory LOG_PATH as 'F:\\test\\' ;
--if exists (select 1 from dba_tables where table_name='WAP_SPHTTP'){
drop table ET_WAP_SPHTTP;CREATE TABLE ET_WAP_SPHTTP
(
GATEWAY_NAME CHAR(16),
WAP_HTTP CHAR(15),
GATEWAY_TYPE CHAR(16)
)ORGANIZATION EXTERNAL
(
TYPE oracle_loader
DEFAULT DIRECTORY DATA_PATH
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE
BADFILE LOG_PATH: 'WAP_SPHTTP.bad' ----记录异常的日志文件名称
LOGFILE LOG_PATH: 'WAP_SPHTTP.log' ----记录加载的日志文件名称
FIELDS TERMINATED BY '|' ----表示列分隔符为'|' ; 即是用数线作为分隔符
MISSING FIELD VALUES ARE NULL ----将数据加载到以下字段
(
GATEWAY_NAME ,
WAP_HTTP ,
GATEWAY_TYPE
))LOCATION
(
'WAP_SPHTTP.txt' ---要加载的数据文件名称文件
)
)REJECT LIMIT 1000
PARALLEL;
alter table WAP_SPHTTP nologging;
alter table WAP_SPHTTP parallel;
truncate table WAP_SPHTTP;
commit;
alter session enable parallel dml;
insert into WAP_SPHTTP select * from ET_WAP_SPHTTP;
DROP TABLE ET_WAP_SPHTTP;
commit;
alter session disable parallel dml;set timing off;
执行 sql>@f:/test/http.sql错误信息如下:已用时间: 00: 00: 00.00
insert into WAP_SPHTTP select * from ET_WAP_SPHTTP
*
第 1 行出现错误:
ORA-29913: 执行 ODCIEXTTABLEOPEN 调出时出错
ORA-29400: 数据插件错误KUP-00554: error encountered while parsing access
parameters
KUP-01005: syntax error: found "minussign": expecting one of: "badfile,
byteorder, characterset, column, data, delimited, discardfile,
disable_directory_link_check, exit, fields, fixed, load, logfile, language,
nodiscardfile, nobadfile, nologfile, date_cache, processing, readsize, string,
skip, territory, varia"
KUP-01007: at line 2 column 41
ORA-06512: 在 "SYS.ORACLE_LOADER", line 19
下面贴出我的外部表文件(http.sql)内容如下:
set timing on;
create or replace directory DATA_PATH as 'F:\\test\\' ;
create or replace directory LOG_PATH as 'F:\\test\\' ;
--if exists (select 1 from dba_tables where table_name='WAP_SPHTTP'){
drop table ET_WAP_SPHTTP;CREATE TABLE ET_WAP_SPHTTP
(
GATEWAY_NAME CHAR(16),
WAP_HTTP CHAR(15),
GATEWAY_TYPE CHAR(16)
)ORGANIZATION EXTERNAL
(
TYPE oracle_loader
DEFAULT DIRECTORY DATA_PATH
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE
BADFILE LOG_PATH: 'WAP_SPHTTP.bad' ----记录异常的日志文件名称
LOGFILE LOG_PATH: 'WAP_SPHTTP.log' ----记录加载的日志文件名称
FIELDS TERMINATED BY '|' ----表示列分隔符为'|' ; 即是用数线作为分隔符
MISSING FIELD VALUES ARE NULL ----将数据加载到以下字段
(
GATEWAY_NAME ,
WAP_HTTP ,
GATEWAY_TYPE
))LOCATION
(
'WAP_SPHTTP.txt' ---要加载的数据文件名称文件
)
)REJECT LIMIT 1000
PARALLEL;
alter table WAP_SPHTTP nologging;
alter table WAP_SPHTTP parallel;
truncate table WAP_SPHTTP;
commit;
alter session enable parallel dml;
insert into WAP_SPHTTP select * from ET_WAP_SPHTTP;
DROP TABLE ET_WAP_SPHTTP;
commit;
alter session disable parallel dml;set timing off;
执行 sql>@f:/test/http.sql错误信息如下:已用时间: 00: 00: 00.00
insert into WAP_SPHTTP select * from ET_WAP_SPHTTP
*
第 1 行出现错误:
ORA-29913: 执行 ODCIEXTTABLEOPEN 调出时出错
ORA-29400: 数据插件错误KUP-00554: error encountered while parsing access
parameters
KUP-01005: syntax error: found "minussign": expecting one of: "badfile,
byteorder, characterset, column, data, delimited, discardfile,
disable_directory_link_check, exit, fields, fixed, load, logfile, language,
nodiscardfile, nobadfile, nologfile, date_cache, processing, readsize, string,
skip, territory, varia"
KUP-01007: at line 2 column 41
ORA-06512: 在 "SYS.ORACLE_LOADER", line 19
百度、GOOGLE关于这个问题的文章,我基本都看了,也都试了。
但还是不行,郁闷中,大侠们帮帮忙啊!