建立SQL:
-- Create directory
create or replace directory A
as 'D:\a';
create or replace directory A1
as 'D:\a1';
--grant
grant read,write on directory a to test;
grant read,write on directory a1 to test;
-- Create table
drop table ext_table1;
create table ext_table1
(
v1 varchar2(30),
v2 varchar2(30),
v3 varchar2(30)
)
organization external
(
type oracle_loader
default directory a
access parameters
(
records delimited by newline
badfile a1:'ext_table_bad.txt'
logfile a1:'log.log'
fields terminated by ','
missing field values are null
(v1,v2,v3)
)
location('ext_tab1.txt')
)
parallel
reject limit unlimited;
----select
SELECT * FROM EXT_TABLE1;
报告:
ORA-29400 KUP-04063 错误 UUnable to open log file log.log
-- Create directory
create or replace directory A
as 'D:\a';
create or replace directory A1
as 'D:\a1';
--grant
grant read,write on directory a to test;
grant read,write on directory a1 to test;
-- Create table
drop table ext_table1;
create table ext_table1
(
v1 varchar2(30),
v2 varchar2(30),
v3 varchar2(30)
)
organization external
(
type oracle_loader
default directory a
access parameters
(
records delimited by newline
badfile a1:'ext_table_bad.txt'
logfile a1:'log.log'
fields terminated by ','
missing field values are null
(v1,v2,v3)
)
location('ext_tab1.txt')
)
parallel
reject limit unlimited;
----select
SELECT * FROM EXT_TABLE1;
报告:
ORA-29400 KUP-04063 错误 UUnable to open log file log.log
参考