This discussion is archived
1 Reply Latest reply: Feb 9, 2007 1:09 PM by Nicolas.Gasparotto RSS

can u help me

560465 Newbie
Currently Being Moderated
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