Loading multiple Varchar2(2000) cols with SQL*Loader
From: Brent Albrecht <spambusterbalbrecht_at_envistatech.com>
Date: 2000/05/25
Message-ID: <mxdX4.5580$eAM1.26083485_at_tomcat.sk.sympatico.ca>#1/1
Date: 2000/05/25
Message-ID: <mxdX4.5580$eAM1.26083485_at_tomcat.sk.sympatico.ca>#1/1
I have a tab-delimited data file with multiple (30) columns of character data, each up to 2000 characters in length. I get the error "ORA-1026 Multiple buffers of size > 4000 in the bind list" unless I specify ROWS=1 on the command line. This causes performance to be less than desirable. Can anbody tell me if I'm doing something wrong ? I would like to specify a large bindsize and load multiple rows. I would appreciate any help that anybody can offer.
Brent Received on Thu May 25 2000 - 00:00:00 CEST