cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Loader Error

Prabhu_11
Occasional Contributor

SQL Loader Error

have oracle 8.1.6.0.0 running on Windows NT.
When I run SQL*LOader

sqlldr direct=n bindsize=20000000 rows=5000 control=$SQL_CTL_FILE data=$DEL_FILE_NAME log=$SQL_LOG_FILE userid=$SQL_USER_NAME/$SQL_PASSWORD@$SQL_CONN_STRING errors=2 &

i'm getting

SQL*Loader-704 Internal Error : Maximum
record must be <= 10000000.

I tried changing bindsize and rows options.
Still getting same error.

Any help ?? !!

Thanks
Raj
1 REPLY
Jean-Luc Oudart
Honored Contributor

Re: SQL Loader Error

Hi

is the message "maximum record length must be <=10000000 ?

if yes you may have hit a bug :
[BUG:1986657] SQL*LOADER-704: INTERNAL ERROR: MAXIMUM RECORD LENGTH MUST BE <= [10000000]
Ver(s): 8.1.7 Fixed Ver(s): 9.0.1.4, 9.2.0.1
Symptom(s):
- SQL*LOADER-704: INTERNAL ERROR: MAXIMUM RECORD LENGTH MUST BE <= [10000000]
Available Workaround(s): None


SQL*LOADER-704: INTERNAL ERROR: MAXIMUM RECORD LENGTH MUST BE <= [10000000]
--------------------------------------------------------------------------------


Hdr: 1986657 8.1.7.0.0 RDBMS 8.1.7.0.0 PRODID-5 PORTID-453 Abstract: SQL*LOADER-704: INTERNAL ERROR: MAXIMUM RECORD LENGTH MUST BE <= [10000000] *** 09/10/01 02:48 pm *** This error will be displayed when the READSIZE is greater than 10000000, a stream format file is being read and there is a record that is being written to the bad or the discard file. . The workaround is to specify a readsize of 10000000



more information on Metalink
Regards
Jean-Luc
fiat lux