Re: Oracle Directory problem
Create directory mydir as 'd:\';
-----------------------------------------
grant read,write on directory mydir to debasis;
-----------------------------------------
create table extemp1
(
empno number(4),
ename varchar2(10),
job varchar2(9),
mgr number(4),
hiredate date,
sal number(7,2),
comm number(7,2),
deptno number(2) )
organization external ( type oracle_loader default directory mydir
access parameters ( records delimited by newline skip 1 fields terminated by ','
( empno char, ename char, job char, mgr char, hiredate char, sal char, comm char, deptno char ))
location('data.lst') )
reject limit 1 ;
try the above code,it will solve your problem