首先创建目录DIR_EXTERNAL_TABLE 目录创建成功,然后授权。外部表创建
CREATE TABLE tbl_external_table_test(
name VARCHAR2(50),
studentno VARCHAR2(50),
hometown VARCHAR2(50)
)ORGANIZATION EXTERNAL
(
TYPE oracle_loader
DEFAULT DIRECTORY DIR_EXTERNAL_TABLE
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ','
)LOCATION('external_test.txt')
)REJECT LIMIT UNLIMITED
表创建成功select * from tbl_external_table_test 报如下错误
ORA-29913: 执行 ODCIEXTTABLEOPEN 调出时出错
ORA-29400: 数据插件错误KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "column, debug, exit, fields, records"
KUP-01008: the bad identifier was: record
KUP-01007: at line 1 column 1
ORA-06512: 在 "SYS.ORACLE_LOADER", line 19
ORA-06512: 在 line 1
CREATE TABLE tbl_external_table_test(
name VARCHAR2(50),
studentno VARCHAR2(50),
hometown VARCHAR2(50)
)ORGANIZATION EXTERNAL
(
TYPE oracle_loader
DEFAULT DIRECTORY DIR_EXTERNAL_TABLE
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ','
)LOCATION('external_test.txt')
)REJECT LIMIT UNLIMITED
表创建成功select * from tbl_external_table_test 报如下错误
ORA-29913: 执行 ODCIEXTTABLEOPEN 调出时出错
ORA-29400: 数据插件错误KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "column, debug, exit, fields, records"
KUP-01008: the bad identifier was: record
KUP-01007: at line 1 column 1
ORA-06512: 在 "SYS.ORACLE_LOADER", line 19
ORA-06512: 在 line 1
解决方案 »
- oracle数据插入的怪问题,请高手指教!
- oracle 10g启动控制台失败,详细如下
- oracle 10g数据库与应用服务器安装在同一台机器上,环境变量究竟应该如何设置
- 用循环该怎么写?
- ORCAL建库
- 变量赋值的问题,我在函数里定义了两个变量,我想调用函数,手动输入字符,自动将字符赋值给变量并执行函数,怎么实现?
- 救命啊。。哪里可以下载到oracle8i for linux啊。。。在网上找了好多天了。。没有一个能下载的地址。。
- ▉▉▉▉▉▉高手请进,关于listener.ora的问题,响影OracleOraHome90Agent服务的工作?
- 完全安装完Oracle8i后。。。
- 关于Oracle多行数据显示在一行的 SQL 求教
- oracle 客户端字符集问题
- 一个奇怪的问题,连接时卡死,无响应
badfile DIR_EXTERNAL_TABLE:'test.bad'
logfile DIR_EXTERNAL_TABLE:'test.log'
CREATE TABLE tbl_external_table_test(
name VARCHAR2(50),
studentno VARCHAR2(50),
hometown VARCHAR2(50)
)ORGANIZATION EXTERNAL
(
TYPE oracle_loader
DEFAULT DIRECTORY DIR_EXTERNAL_TABLE
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ','
(name char,
studentno char,
hometown char)
)LOCATION('external_test.txt')
)REJECT LIMIT UNLIMITED