Loading Constant Date
Date: 21 Aug 2002 13:14:03 -0700
Message-ID: <960f9005.0208211214.a0679f0_at_posting.google.com>
Does anyone know how to load a constant date using Oracle8i SQL*Loader
direct-path? have a date that includes a time element. Have tried
UNRECOVERABLE
"to_date('080102.13:15:27','mmddyy.hh24:mi:ss')", but that only works
in conventional. Also have tried numerous permutations, including the
"constant" keyword. No luck. Cannot use sysdate. Am aware that I
can change the default NLS date format, but hoping there is a simple
SQL*Loader solution. Has to be a common problem. An example of my
control file is as follows:
LOAD DATA
truncate
INTO TABLE cust
SORTED INDEXES (idx1_cust)
FIELDS TERMINATED BY '$'
TRAILING NULLCOLS
(
CUST_NUM,
MGR_NUM,
AAVR_ID,
ISSD_DT DATE "mm/dd/yyyy hh24:mi:ss",
STATUS,
NM,
EXT_DT "to_date('080102.13:15:27','mmddyy.hh24:mi:ss')"
)
SQL*Loader: Release 8.1.7.4.0 - Production on Wed Aug 21 15:29:43 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL*Loader-417: SQL string (on column EXT_DT) not allowed in direct path.
Thanks,
Paul Received on Wed Aug 21 2002 - 22:14:03 CEST