Re: [sqlldr] upload number datatype from varchar2 datatype in ctl file
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 06 Mar 2008 19:51:36 +0100
Message-ID: <49fbb$47d03d39$524b5c40$31489@cache3.tilbu1.nb.home.nl>
Date: Thu, 06 Mar 2008 19:51:36 +0100
Message-ID: <49fbb$47d03d39$524b5c40$31489@cache3.tilbu1.nb.home.nl>
chijar wrote:
[snip]
>
> This is my sh. file:
> # /bin/bash
> export ORACLE_SID=plelpp
> export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
> export PATH=$PATH:$ORACLE_HOME/bin
> sqlldr USERID=system, CONTROL=T818COMP.ctl, LOG=T818COMP.log,
> data=10pemvx_datoscompdom_20080304165740.dat, bad=T818COMP.bad,
> discard=T818COMP.dsc
>
Lothar has a point; nowhere do I see an export of NLS settings.
-- Regards, Frank van Bortel Top-posting in UseNet newsgroups is one way to shut me upReceived on Thu Mar 06 2008 - 12:51:36 CST