External Table Newbie Question
I have a file that I am trying to load using external table but I am getting an error. It think it is a problem with the newline character.
I get the following error
KUP-04023: field start is after end of record
I have the external table record defined as
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY VERIFY_DIR
( records delimited by newline
When I do an od -cx command on the file I get
2c31 3632 3737 3037 3920 4245 4e7c 0a54
0001020 R | 1 | 2 0 0 4 1 1 | \n
527c 317c 3230 3034 3131 7c0a
Is this different than the newline defined in my external table???
From the 9i db util gd.:
If the following conditions are true, then you must use hexadecimal digits to identify the delimiter:
- The character set of the access parameters is different from the character set of the datafile
- Some characters in the delimiter string cannot be translated into the character set of the datafile
The hexadecimal digits are converted into bytes, and there is no character set translation performed on the hexadecimal string.
So if u think it's the newline then guess u'll have to use the hex equivalent of \n (for the newline char!) or try CHARACTERSET US7ASCII?
But do post what worked !!
Click Here to Expand Forum to Full Width