Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

External Tables and Tab Delimited Files

31170Sep 25 2002 — edited Aug 9 2003
Has anyone figured out how to load a tab delimited file using an external table? If I specify "FIELDS DELIMITED BY X'09'" (like in SQL*Loader) it tells me it found an "X" instead of the hexprefix. If I use "\t" as the delimiter, the log file tells me the delimiter is " " (an expansion of the tab).

An interesting fact, although the error message references hexprefix, that word cannot be found searching the Oracle docs on Technet.

Thanks for any help you can give me.
Cary


Code for external table and error message
...
FIELDS terminated by x'09'
...


ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing input commands
KUP-01005: syntax error: found "identifier": expecting one of: "double-quoted-string, eof, hexprefix, single-quoted-string, whitespace"
KUP-01008: the bad identifier was: x
KUP-01007: at line 6 column 25
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2003
Added on Sep 25 2002
2 comments
717 views