ORA-01458 Error question...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-01458 Error question...

  1. #1
    Join Date
    Mar 2001
    Posts
    26
    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

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    How do you copy the data?

  3. #3
    Join Date
    Mar 2001
    Posts
    26
    I use the COPY command in SQL*PLUS.

    Thanks.

  4. #4
    Join Date
    Mar 2001
    Posts
    635
    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

  5. #5
    Join Date
    Mar 2001
    Posts
    26
    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
  •  


Click Here to Expand Forum to Full Width