DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Mar 2006

    exp from WE8MSWIN1252/ imp to UTF8

    Hi all,

    I did an exp on the db with WE8MSWIN1252 and import the file into UTF8 database the import run successful; however, the user had issue with the app, the error is :

    ORA-12899: value too large for column.........

    this is look like the characterset issues but I thought WE8MSWIN1252 is the subset of UTF8.

    any thoughts?

  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    UTF8 needs extra bytes since it is unicode. You need to increase the size of the offending column on the source system and then export and re-import. You can also grab the sql from the table in question and pre-create the table taking care to increase the size of the offending column before you do.
    this space intentionally left blank

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.