hi
i am trying to create an external table

create table ext_table (
i Number,
n Varchar2(20),
m Varchar2(20)
)
organization external (
type oracle_loader
default directory dir_dm
access parameters (
records delimited by newline
fields terminated by ','
missing field values are null
)
location ('xsu.csv') )
reject limit unlimited

this shows an err

SQL> select * from ext_table ;
select * from ext_table
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04063: unable to open log file EXT_TABLE_1120_2808.log
OS error The system cannot find the file specified.
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1


pls help me to solve the problem

Note : dir_dm is a valid directory

Dhanya M

Oracle LazyDBA home page