ORA-01458 Error question...

[gshaf]

Hi guys,

I'm trying to copy data from one table to another. The tables are identical. But, I keep getting this error... According to Oracle, the meaning is:

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.

What the hell are they taking about?? What buffer size??

Any help would greatly be appreciated.

Thanks,
- Gary

[akkerend]

How do you copy the data?

[gshaf]

I use the COPY command in SQL*PLUS.

Thanks.

[santoshym]

Hi

Why dont you put the steps and commands in this thread so that we can try and find out what the problem is

Regards

[gshaf]

This is what I type in SQL*PLUS:

SQL> COPY FROM system/manager@old_instance TO system/manager@new_instance -
> INSERT Table_Name -
> USING SELECT * FROM Table_Name

Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)

ERROR:
ORA-01458: invalid length inside variable character string

SQL>

Any ideas?

- Gary