stewartdwest
Programmer
Happily creating/using Oracle External Tables
Trouble starts when Setting the Access Parameters, specifically Fields Terminated X'2c'
The STRING specification of the terminator works for "," and for ',' but rejects the hexadecimal notation X'2c'
I've standardized on X'b8' for my files delimiter working nicely with other utilities like SQL loader however cannot get the External Table to accept files which use signed values for delimiter.
Trouble starts when Setting the Access Parameters, specifically Fields Terminated X'2c'
The STRING specification of the terminator works for "," and for ',' but rejects the hexadecimal notation X'2c'
I've standardized on X'b8' for my files delimiter working nicely with other utilities like SQL loader however cannot get the External Table to accept files which use signed values for delimiter.
