我用scott用户创建了目录,并授予了权限:
SQL>CREATE OR REPLACE DIRECTORY DUMP_DIR AS '/oradata/exterltab';之后又创建了外部表:
[oracle@ttt exterltab]$ vi student.data
10001@#$kerry@#$male@#$28@#$1
10002@#$jimmy@#$male@#$22@#$1
10003@#$ken@#$male@#$21@#$1
10004@#$merry@#$femal@#$20@#$1CREATE TABLE EXTER_TEST
(
ID NUMBER(5) ,
NAME VARCHAR(12) ,
SEX VARCHAR(8) ,
AGE NUMBER(3) ,
GRADE NUMBER(1)
) ORGANIZATION EXTERNAL
(
type oracle_loader
default directory dump_dir
access parameters
(
records delimited by newline
fields terminated by '@#$'
)
location ('student.data')
);最后访问外部表数据
select * from exter_test报的错误如下:
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file /oradata/exterltab/EXTER_TEST_4525.log
请问怎么解决?
SQL>CREATE OR REPLACE DIRECTORY DUMP_DIR AS '/oradata/exterltab';之后又创建了外部表:
[oracle@ttt exterltab]$ vi student.data
10001@#$kerry@#$male@#$28@#$1
10002@#$jimmy@#$male@#$22@#$1
10003@#$ken@#$male@#$21@#$1
10004@#$merry@#$femal@#$20@#$1CREATE TABLE EXTER_TEST
(
ID NUMBER(5) ,
NAME VARCHAR(12) ,
SEX VARCHAR(8) ,
AGE NUMBER(3) ,
GRADE NUMBER(1)
) ORGANIZATION EXTERNAL
(
type oracle_loader
default directory dump_dir
access parameters
(
records delimited by newline
fields terminated by '@#$'
)
location ('student.data')
);最后访问外部表数据
select * from exter_test报的错误如下:
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file /oradata/exterltab/EXTER_TEST_4525.log
请问怎么解决?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货