CREATE TABLE EXT_CDR_LOG_10
(
ACCT_DATE VARCHAR2(10 BYTE),
INSERT_DATE VARCHAR2(8 BYTE),
GYMSC_FT VARCHAR2(13 BYTE),
FILENAME VARCHAR2(1 BYTE),
FILENAME1 VARCHAR2(1 BYTE),
YES_NO VARCHAR2(2 BYTE),
FILESIZE VARCHAR2(9 BYTE),
DELETE_SUMS VARCHAR2(7 BYTE),
OTHER_SUMS VARCHAR2(8 BYTE)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY DAY_DATA
ACCESS PARAMETERS
( RECORDS DELIMITED BY NEWLINE
nologfile
nobadfile
nodiscardfile
skip 1
FIELDS TERMINATED BY ' ' -- 指定分隔符
(
ACCT_DATE CHAR(10),
INSERT_DATE CHAR(8),
GYMSC_FT CHAR(13),
FILENAME CHAR(1),
FILENAME1 CHAR(1),
YES_NO CHAR(2),
FILESIZE CHAR(9),
DELETE_SUMS CHAR(7),
OTHER_SUMS CHAR(8)
)
)
LOCATION (DAY_DATA:'I10010.AVL')
)
REJECT LIMIT 0
;
运行后,出现这样的错误ORA-29400:数据插件错误KUP-00554:error encountered while parsing access parameters
KUP-01005:syntax error:found"minussign": expecting one of:"column, enclosed, exit, (, ltrim, lrtrim,ldrtrim, missing, notrim, optionally, rtrim, reject"
KUP-01007: at line 6 column 54
ORA-06512: 在 "SYS.ORACLE_LOADER", line 19
(
ACCT_DATE VARCHAR2(10 BYTE),
INSERT_DATE VARCHAR2(8 BYTE),
GYMSC_FT VARCHAR2(13 BYTE),
FILENAME VARCHAR2(1 BYTE),
FILENAME1 VARCHAR2(1 BYTE),
YES_NO VARCHAR2(2 BYTE),
FILESIZE VARCHAR2(9 BYTE),
DELETE_SUMS VARCHAR2(7 BYTE),
OTHER_SUMS VARCHAR2(8 BYTE)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY DAY_DATA
ACCESS PARAMETERS
( RECORDS DELIMITED BY NEWLINE
nologfile
nobadfile
nodiscardfile
skip 1
FIELDS TERMINATED BY ' ' -- 指定分隔符
(
ACCT_DATE CHAR(10),
INSERT_DATE CHAR(8),
GYMSC_FT CHAR(13),
FILENAME CHAR(1),
FILENAME1 CHAR(1),
YES_NO CHAR(2),
FILESIZE CHAR(9),
DELETE_SUMS CHAR(7),
OTHER_SUMS CHAR(8)
)
)
LOCATION (DAY_DATA:'I10010.AVL')
)
REJECT LIMIT 0
;
运行后,出现这样的错误ORA-29400:数据插件错误KUP-00554:error encountered while parsing access parameters
KUP-01005:syntax error:found"minussign": expecting one of:"column, enclosed, exit, (, ltrim, lrtrim,ldrtrim, missing, notrim, optionally, rtrim, reject"
KUP-01007: at line 6 column 54
ORA-06512: 在 "SYS.ORACLE_LOADER", line 19
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货