regarding external tables [message #346673] |
Tue, 09 September 2008 05:52  |
panyam
Messages: 146 Registered: May 2008
|
Senior Member |
|
|
Hi all,
I am trying to read data from a .txt file into externel table.
And i am getting the error when i query the external table.
below is wat i hav done,I have created the Directory ravi_dir also.
file.txt contains
1,one,first
2,two,second
3,three,third
4,four,fourth
SQL> create table ravi_test5(
2 i number,
3 n varchar2(10),
4 m varchar2(10))
5 organization external (
6 type oracle_loader
7 default directory ravi_dir
8 access parameters (
9 records delimited by newline
10 fields delimited by ','
11 missing field values are null
12 )
13 location('file.txt')
14 )
15 reject limit unlimited;
Table created.
SQL> select * from ravi_test5;
select * from ravi_test5
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "delimited": expecting one of: "column,
enclosed, exit, (, ltrim, lrtrim, ldrtrim, missing, notrim, optionally, rtrim,
reject, terminated"
KUP-01007: at line 2 column 8
ORA-06512: at "SYS.ORACLE_LOADER", line 19
|
|
|
|
|
|
|
|