-
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
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY VERIFY_DIR
ACCESS PARAMETERS
( records delimited by newline
When I do an od -cx command on the file I get
T
2c31 3632 3737 3037 3920 4245 4e7c 0a54
0001020 R | 1 | 2 0 0 4 1 1 | \n
527c 317c 3230 3034 3131 7c0a
0001034
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 !!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|