1 Reply Latest reply: Feb 9, 2007 3:09 PM by Nicolas.Gasparotto RSS

    can u help me

    560465
      I can't upload the data from test.csv file to database

      SQL> create or replace directory UTL as 'c:\oracle\product\10.1.0';

      Directory created.

      SQL> grant read, write on directory UTL to swmsprocess;

      Grant succeeded.

      SQL> ed
      Wrote file afiedt.buf

      1 create table scott.test(no varchar(20),name varchar2(30))
      2 organization external
      3 ( type oracle_loader
      4 default directory UTL
      5 access parameters
      6 (fields terminated by ',')
      7 location('test.csv'))
      8* reject limit unlimited
      SQL> /

      Table created.

      SQL> select count(*) from scott.test;
      select count(*) from scott.test
      *
      ERROR at line 1:
      ORA-29913: error in executing ODCIEXTTABLEOPEN callout
      ORA-29400: data cartridge error
      KUP-04063: unable to open log file test_1756_1872.log
      OS error The data is invalid.
      ORA-06512: at "SYS.ORACLE_LOADER", line 19
      ORA-06512: at line 1

      regards
      Lawrence