External Table Rows Not Showing All Data.
Hello,
I have an 80 character line that I am importing into an external table.
80% of the row data imports fine, but some rows are chopped off.
The bytes in the file are as follows.
ABCABC2334 A002 0000001000010000001000000001 000000 00001C
Bytes in external table.
ABCABC2334 A002 0000001000010000001000000001 000000
The bytes in the external table row stop somewhere at the end of 000000 and the 00001C is chopped off.
What whould be the cause of this?
I am able to read the characters at the beginning and toward end of the 80 character line record.
The below external file does the following.
ABCABC2334 A002 0000001000010000001000000001 000000 01C
I can even do an external table definition ( c1 char(1), c2 char(1),.... c80 char(1) and all the characters show up fine in the specified columns.
Below is the latest external table definition. The "middle" column still shows this behavior. Basically, it is in the file and can be seen with each character in the line definined but not as a group of characters.
DB CHARACTERSET WEBISO8859P1
CREATE TABLE EXT_PROJ_1
(
field1 char(6 BYTE),
field2 char(4 BYTE),
middle char(67 BYTE),
field3 char(3 byte),
cr char(2 byte)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY EXP_DIR
ACCESS PARAMETERS
(
RECORDS delimited by '\r\n'
FIELDS (field1 position(1:6),
field2 position(7:10),
middle position(11:77),
field3 position(78:80),
cr position(81:82)
)
)
LOCATION (EXP_DIR:'ext_proj_1.txt')
)
REJECT LIMIT 1
noPARALLEL
NOMONITORING;
Edited by: 917320 on Mar 13, 2012 9:07 AM