-
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
-
How do you copy the data?
-
I use the COPY command in SQL*PLUS.
Thanks.
-
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
Santosh
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|