ora-12899 during import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ora-12899 during import

  1. #1
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    ora-12899 during import

    Hi friends ,

    I am importing database from version 8.1.7 Enterprise Edition to 10g Standard Edition.

    everything was working fine but got following error message .

    ora-12899 value too large for column ..

    This is a huge database of 100GB.

    any workarounds for fixing this error.

    Thanks
  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    isnt the error obvious, you are trying to enter data that is too big for the column

  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    but how did it fit in .. table structure is same ...
    data is there in varchar2(72) ..
    and i am importing into similar structure with varchar2(72)width ..

    only difference is i am changing operating system
    from
    1) open VMS to windows
    2) Enterprise edition 8.1.7 to standard 10g
    3) 64 bit to 32 bit
    4) characterset is different

    if anybody could tell which could be causing .. then we can redo this operation .... while importing it say width is 74 ...


    following is the error message as seen in log file

    IMP-00019: row rejected due to ORACLE error 12899
    IMP-00003: ORACLE error 12899 encountered
    ORA-12899: value too large for column "ISR"."GRP_BKP_052504"."GRP_NM" (actual: 75, maximum: 72)
    Column 1 2634935
    Column 2 26301
    Column 3 197
    Column 4 HOVEDKONTORET: NØKKELPERSON [FUNKSJONÆR MED HØYSK...
    Column 5 W
    Column 6 0
    Column 7 0
    Column 8 X
    Column 9 A
    Column 10 1:05; 3:3
    Column 11 79
    Column 12 CAR0439L
    Column 13 197
    Last edited by prakashs43; 08-27-2004 at 07:04 PM.

  4. 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