Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql loader problem

Re: sql loader problem

From: Brian Howard <bh_at_creditwatch-inc.com>
Date: Wed, 29 Sep 1999 16:31:04 GMT
Message-ID: <37F23BC7.7E68F4E2@creditwatch-inc.com>


> the control file looks like the following:
>
> LOAD DATA
> REPLACE
> INTO TABLE QUANAYA.LOADER
> FIELDS TERMINATED BY " "
> TRAILING NULLCOLS
> (
> BILL_NR CHAR,
> CURR_AMT_DUE DECIMAL EXTERNAL,
> CUST_NM CHAR,
> DELINQ_AMT_DUE DECIMAL EXTERNAL,
> ST_CD CHAR,
> TN_EFF_DT DATE "YYMMDD"
> )

"Lars Sjöström" wrote:

> What is in the ctl-file?
> Is it a valid SQLloader control file? If it is, maybe it is not ended with a
> return or something.
>
> SQLLoader always needs a control file.
>
> Lars
> Linköping
Received on Wed Sep 29 1999 - 11:31:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US