+ Reply to Thread
Results 1 to 3 of 3
  1. 08-27-2004 05:05 PM #1
    prakashs43
    prakashs43 is offline Senior Member
    Join Date
    May 2002
    Location
    USA
    Posts
    460

    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
    Reply With Quote Reply With Quote
  2. 08-27-2004 05:20 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    isnt the error obvious, you are trying to enter data that is too big for the column
    Reply With Quote Reply With Quote
  3. 08-27-2004 05:26 PM #3
    prakashs43
    prakashs43 is offline Senior Member
    Join Date
    May 2002
    Location
    USA
    Posts
    460
    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 06:04 PM.
    Reply With Quote Reply With Quote
    4. « Previous Thread | Next Thread »

    Bookmarks

    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