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.
How do you copy the data?
I use the COPY command in SQL*PLUS.
Why dont you put the steps and commands in this thread so that we can try and find out what the problem is
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)
ORA-01458: invalid length inside variable character string
Click Here to Expand Forum to Full Width