Using Date Mask on ET Make No Rows Returned

From: Resant <resant_v_at_yahoo.com>
Date: 5 Jun 2006 21:33:55 -0700
Message-ID: <1149568435.850341.143810@u72g2000cwu.googlegroups.com>

Hi all,

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 Received on Mon Jun 05 2006 - 23:33:55 CDT