Database Software

Hi, guys:

please help me on this problem: I tried to load data from bunch of csv files on linux server to external tables. However, the table is created without data. There is no warning message. but I check csv file with cat, there is data. here is query.

create table worcs.ACBRD_0050_EXT(
CODE VARCHAR2(4),
POL_NBR VARCHAR2(8),
CENT VARCHAR2(2),
YR VARCHAR2(2),
SEQ VARCHAR2(1),
CLAIM_NBR VARCHAR2(4),
SORT_INIT VARCHAR2(2),
SORT_SEQ VARCHAR2(2),
ENTER_CC_50 VARCHAR2(2),
ENTER_YY_50 VARCHAR2(2),
ENTER_MM_50 VARCHAR2(2),
ENTER_DD_50 VARCHAR2(2),
PREM_DUE_50 NUMBER(11,2),
POL_STS_50 VARCHAR2(1),
POL_AUDT_TYPE_50 VARCHAR2(1),
CHANGE_50 VARCHAR2(1),
REV_AUD_DED_50 VARCHAR2(1),
AUDIT_ID_50 VARCHAR2(8),
BILL_CC_50 VARCHAR2(2),
BILL_YY_50 VARCHAR2(2),
BILL_MM_50 VARCHAR2(2),
BILL_DD_50 VARCHAR2(2)
)
organization external ( 
default directory ksds
access parameters
 ( records delimited by newline 
  badfile xtern_log_dir: 'xtern_acbrd_0050.bad'
 logfile xtern_log_dir:'xtern_acbrd_0050.log'
  discardfile xtern_log_dir:'xtern_acbrd_0050.dsc'
  ) location ('acbrd-0050.csv') ) REJECT LIMIT unlimited 
;

And in linux it shows:

[oracle@VM-OracleBI ksds]$ cat acbrd-0050.csv
0050|00508081|1|11|1|    |  |  |1|11|10|31| 000001638.00|L|C|Y|A|CONF    | |  |  |  |
0050|01803167|1|10|1|    |  |  |1|11|10|27| 000000896.00|L|C|Y|A|CONF    | |  |  |  |
[oracle@VM-OracleBI ksds]$