Do you have read & write access to dir_dm?


Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Dhanya
[mailto:oracledba-ezmlmshield-x30707312.[Email address protected]
Sent: Monday, August 16, 2004 1:15 AM
To: LazyDBA Discussion
Subject: External Table

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


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see
http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to
these terms:http://www.lazydba.com/legal.html







Oracle LazyDBA home page