|
-
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???
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
|