dsmcd wrote:
>
> Hello...I'm a newbie to sqlldr so please bare with me.
>
> One field in my table is a date&time field. The ctl file
> defines the field format as
>
> "Mon DD YY HH24:MI:SS"
>
> But for some records in the dat file, the date&time
> field does not a date, it ONLY has the time.
>
> Sqlldr seems to handle loading a date&time field
> when there's just a date, but it considers a record
> to be bad when a date&time field has just a time.
>
> In other words...
>
> Any way to get Sqlldr to load
> " 09:26:15"
> into a field defined as
> "Mon DD YY HH24:MI:SS"?
>
> Thx,
> D.
There is date&time field. Oracle DATE datatypes imply a time,
regardless of what a controlfile says.
Read the Oracle SQL Reference docs section about data types. Also see
the Utilities docs about SQL*LOader and pay attention to the case
studies.
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Fri Oct 12 2001 - 09:10:37 CDT
