Re: ora-01458

From: <dp_devnull_at_yahoo.com>
Date: Wed, 26 Apr 2000 18:59:13 -0700
Message-Id: <10479.104245@fatcity.com>

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
>

---

Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger. Received on Wed Apr 26 2000 - 20:59:13 CDT