External Tables and Tab Delimited Files
31170Sep 25 2002 — edited Aug 9 2003Has 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