Justin,

You gave some advice awhile back in regards to creating an external
table. You suggested checking on file permissions. Here was the
original post. I was wondering if you could tell me how to check file
permission on a windows 2000 machine running oracle 9i release 2. I'm
having the same problem and described below and I think it is a file
permission problem like you suggested.


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