SQL & PL/SQL

Hi All,

I wanted to know whether FILLER columns can be defined in the Access Parameters section when External tables are defined? I have implemented it in the following way and get an error when I try to see the data in the table.


create table load2(
chrom varchar2(100),
)
ORGANIZATION EXTERNAL (TYPE ORACLE_LOADER DEFAULT DIRECTORY MY_LOAD
access parameters ( records delimited by newline
fields terminated by '\t'
lrtrim REJECT ROWS WITH ALL NULL FIELDS
(
CHROM char(100),
POS FILLER char(100)
)
) location ('test.txt'))
reject limit unlimited;

The error I get is " KUP-01005:syntax error: found "identifier":expecting one of:"binary_double,binary_float,comma,char,date,defaultif, decimal, double, float, integer, (,nullif,oracle_date,oracle_number,position,raw,recnum,),unsigned,varrawc,varchar,varraw,varcharc,zoned"
KUP-01008:the bad identifier was: FILLER"

I tried placing FILLER at different positions and it still gives me an error.

Thanks,
Nikita