SELECT EXTERNAL TABLE error
Hi There,
Env: Solaris 9, Oracle 9i
I have a sql script that creates a table fine but fails on select *.
In Unix, I grant all permission for my directory, /export/home/james'.
Any advise?
SQL> select count(*) from deadholding_ext;
select count(*) from deadholding_ext
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04063: unable to open log file ext.log
OS error Permission denied
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1
Here is my sql:
--------------
drop DIRECTORY james_data;
CREATE DIRECTORY james_data AS '/export/home/james';
drop table deadholding_ext;
CREATE TABLE deadholding_ext
(deadholding_pidm number(8),
deadholding_id varchar(9),
deadholding_LName varchar(60),
deadholding_Fname varchar(15),
deadholding_MName varchar(15),
deadholding_Date date)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY james_data
ACCESS PARAMETERS
(
records delimited by newline
badfile james_data:'ext.bad'
logfile james_data:'ext.log'
fields terminated by ','
missing field values are null
( deadholding_pidm, deadholding_id, deadholding_LName, deadholding_FName, deadholding_MName,
deadholding_Date char date_format date mask "dd-mon-yyyy"
)
)
LOCATION ('boyDead.csv')
)
PARALLEL
REJECT LIMIT UNLIMITED;
----------------
Unix Permission:
james@bmssun2./export/home/james>ls -lt
total 1148
drwxrwxrwx 2 james staff 512 Jun 2 14:05 data
