Using Date Mask on ET Make No Rows Returned
Resant
I'm trying to use external table in Oracle 9i. One of my field is in
date datatype, so I use date mask to create the external tables, it
works ok, no error but when I select the table it return no rows.
Below is my script :
CREATE TABLE EXT_TABLES
(
A VARCHAR2(50 BYTE) ,
B NUMBER ,
C VARCHAR2(7 BYTE) ,
D VARCHAR2(10 BYTE),
E VARCHAR2(20 BYTE),
F DATE,
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY EXT_TABLES
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ','
MISSING FIELD VALUES ARE NULL
(
A ,
B ,
C ,
D ,
E ,
F DATE "DD/MM/YYYY"
)
)
LOCATION ('data.csv')
)
REJECT LIMIT UNLIMITED;
Is there something I've missed? Please help me, thank you
Regards,
Resant
Sybrand Bakker
>Is there something I've missed? Please help me, thank you
Looking in .log, .bad and .dsc files, I guess
--
Sybrand Bakker, Senior Oracle DBA