2 Replies Latest reply on Nov 21, 2012 3:18 AM by 951599

    need help on setting for external table


      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" .