This discussion is archived
2 Replies Latest reply: Nov 20, 2012 7:18 PM by 951599 RSS

need help on setting for external table

951599 Newbie
Currently Being Moderated

Oracle Database 10g Express Edition Release - Product
PL/SQL Release - Production
CORE Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version - Production

I am new in external table so i have tried following cmd.

create directory dir_1 as 'E:\ora_dirt' ;

grant read, write on directory dir_1 to HR;

select * from all_directories;

create table emp_ext
(emp_id number,
emp_name varchar2(30)
organization external
type oracle_loader
default directory DIR_1
access parameters
fields terminated by ','
( id , name)
location ('emp.dat')
reject limit unlimited;

select * from emp_ext

since I am not able to see DIR_1 in E:\ drive due to which i havnt created  'emp.dat' file and on executing select on external table i m geting expected error
*"ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-04043: table column not found in external source: EMP_ID"*

please tell me how to create that file in directory "DIR_1" .



  • Correct Answers - 10 points
  • Helpful Answers - 5 points