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

Home -> Community -> Mailing Lists -> Oracle-L -> SQl Loader error sql*loader 704

SQl Loader error sql*loader 704

From: Girijan Puthran <girijan.puthran_at_db.com>
Date: Wed, 12 Dec 2001 23:25:25 -0800
Message-ID: <F001.003DB839.20011212230518@fatcity.com>

I am using Oracle version 8.1.6.3.0 on a sun 2.6 server and am getting the following error when trying to load a table using sql loader.

SQL*Loader-704: Internal error: Maximum record length must be <= [10000000]

The problem occurs when I set the bindsize parameter value to > 10000000 , the surprising fact is that the same load works fine on the devt version of the same database.The devt database are identical to the prod database settings.Metalink didn't prove to be much of a help and I was wondering if this is related to some kind of a bug. Any help would be greatly appreciated.                                                                                  

Girijan

--

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

--

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

Author: Girijan Puthran
  INET: girijan.puthran_at_db.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

--------------------------------------------------------------------
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 Thu Dec 13 2001 - 01:25:25 CST

Original text of this message

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