| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ora-01458
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFB043.F7F039C0
Content-Type: text/plain;
charset="iso-8859-1"
Adjust to what values? By the way, export import is working for this table.
Alex Hillman
-----Original Message-----
From: dp_devnull_at_yahoo.com [mailto:dp_devnull_at_yahoo.com]
Sent: Wednesday, April 26, 2000 11:13 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ora-01458
Alex,
See what your copycommit and arrysize are set to using the show command, and see if you can adjust them.
Good Luck
Dennis
dp_devnull_at_yahoo.com
On 26 Apr 2000, at 16:28, Alex Hillman wrote:
> I am trying to execute script in sqlplus
>
> set long 80000
>
> delete from ref_cpt;
> commit;
>
> copy from demo01/demo_at_sdedbs02 insert ref_cpt using select * from ref_cpt;
>
> exit
>
> It gives me error ora-01458.
>
> Cause: An attempt was made to bind or define a variable character string
> with a buffer length less than the minimum requirement.
>
> Action: Increase the buffer size or use a different type.
>
> This table has one column with long datatype.
>
>
> Any ideas pleas
>
-- Author: INET: dp_devnull_at_yahoo.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). ------_=_NextPart_001_01BFB043.F7F039C0 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0"> <TITLE>RE: ora-01458</TITLE> </HEAD> <BODY> <P><FONT SIZE=2>Adjust to what values? By the way, export import is working for this table.</FONT> </P> <P><FONT SIZE=2>Alex Hillman</FONT> </P> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>From: dp_devnull_at_yahoo.com [<A HREF="mailto:dp_devnull_at_yahoo.com">mailto:dp_devnull_at_yahoo.com</A>]</FONT> <BR><FONT SIZE=2>Sent: Wednesday, April 26, 2000 11:13 PM</FONT> <BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>Subject: Re: ora-01458</FONT> </P> <BR> <P><FONT SIZE=2>Alex,</FONT> </P> <P><FONT SIZE=2>See what your copycommit and arrysize are set to using the show </FONT> <BR><FONT SIZE=2>command, and see if you can adjust them.</FONT> </P> <P><FONT SIZE=2>Good Luck</FONT> <BR><FONT SIZE=2>Dennis</FONT> </P> <P><FONT SIZE=2>dp_devnull_at_yahoo.com</FONT> <BR><FONT SIZE=2> </FONT> </P> <P><FONT SIZE=2>On 26 Apr 2000, at 16:28, Alex Hillman wrote:</FONT> </P> <P><FONT SIZE=2>> I am trying to execute script in sqlplus</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> set long 80000</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> delete from ref_cpt;</FONT> <BR><FONT SIZE=2>> commit;</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> copy from demo01/demo_at_sdedbs02 insert ref_cpt using select * from ref_cpt;</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> exit</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> It gives me error ora-01458.</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> Cause: An attempt was made to bind or define a variable character string</FONT> <BR><FONT SIZE=2>> with a buffer length less than the minimum requirement. </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> Action: Increase the buffer size or use a different type. </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> This table has one column with long datatype.</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> Any ideas pleas</FONT> <BR><FONT SIZE=2>> </FONT> </P> <BR> <BR> <P><FONT SIZE=2>__________________________________________________</FONT> <BR><FONT SIZE=2>Do You Yahoo!?</FONT> <BR><FONT SIZE=2>Talk to your friends online with Yahoo! Messenger.</FONT> <BR><FONT SIZE=2>http://im.yahoo.com</FONT> </P> <P><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Author: </FONT> <BR><FONT SIZE=2> INET: dp_devnull_at_yahoo.com</FONT> </P> <P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT>Received on Thu Apr 27 2000 - 07:27:35 CDT
 |
 |