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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: sqlload

RE: sqlload

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 03 Sep 2003 08:34:34 -0800
Message-ID: <F001.005CEA49.20030903083434@fatcity.com>


Congratulations Thomas!

You win the eagle-eye prize of the day! Unfortunately it is a virtual prize. Funny what an obscure error sqlldr produced.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, September 02, 2003 1:05 PM To: Multiple recipients of list ORACLE-L

Fawzia,

Try the following (change parfile= to control=)

sqlldr control=pants.ctl log=me.log

parfile is for imp/exp.

Good Luck!

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Tuesday, September 02, 2003 1:20 PM To: Multiple recipients of list ORACLE-L

PLEASE!!!! Can someone help??I have a sqlloader control file below and I am getting the following error when I run it and I just cant see what is wrong!!!

Rgds

Fawzia
oracle_at_devnodea> sqlldr parfile=pants.ctl log=me.log LRM-00110: syntax error at 'LOAD'
LRM-00113: error when processing file 'pants.ctl'

Control file:

LOAD DATA
INFILE 'gazza2.csv'
APPEND
INTO TABLE olsr10_tlmif2.gazetteer1
fields terminated by ','
trailing nullcols
(postcode_prefix_spaced char,
filler1 char,
postcode_prefix char,
filler2 char,
postcode_range char,
filler3 char,
town char,
filler4 char,
county char,
valid_date char)



Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone.
Thank you for your co-operation.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Malik, Fawzia
  INET: Fawzia.Malik_at_bskyb.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Sep 03 2003 - 11:34:34 CDT

Original text of this message

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