Message-Id: <10479.104238@fatcity.com> From: Alex Hillman Date: Wed, 26 Apr 2000 19:10:03 -0400 Subject: 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_01BFAFD4.8EDFC8C0 Content-Type: text/plain; charset="iso-8859-1" I am trying to execute script in sqlplus set long 80000 delete from ref_cpt; commit; copy from demo01/demo@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 ------_=_NextPart_001_01BFAFD4.8EDFC8C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ora-01458

I am trying to execute script in = sqlplus

set long 80000

delete from ref_cpt;
commit;

copy from demo01/demo@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