SQL*Loader: How to skip data

[Quoted] Suppose one has table A with two columns: DATE and VARCHAR2

Suppose one needs to load this table from the following datafile

1998/aug/19 15:25:26.320000, 'a'
1998/aug/19 16:25:27.163200, 'b'
....

Is there a way to do this?

I am trying to

INTO TABLE a
fields terminated by ',' (
  d DATE 'YYYY/mon/DD HH24:MI:SS'
  v CHAR
)

But it generates errors because of the remainder of the date (the microseconds).

This situation is not farfetched and occurs when one wants to move data from SQLANY50 to Oracle.

Thanks.
k& Received on Wed Aug 19 1998 - 17:30:18 CEST