Why not create a load/staging table that matches your data types, then use PL/SQL to load into final destination table(s)?

Todd Pepling
[Email address protected]
724-766-3492

________________________________

From: Trincia Nicholas F. [mailto:oracledba-ezmlmshield-x42431805.[Email address protected]
Sent: Wed 11/28/2007 16:41
To: LazyDBA Discussion
Subject: SQL Loader question



We are trying to do a SQL load of some VMS T4 metric data and are
struggling with configuring our control file. The core problem is the
source data date formats for sample_dt_tm uses a single digit for days 1
through 9. We don't want to transform the data, but instead want
SQL*ldr to do it for us. We are using Oracle 9.2.0.5.0. We are losing
our hair on this issue. Any help to keep all follicles in place would
be a "hairsaver".

Nick




Oracle LazyDBA home page