ORA-29874 DRG-50857: oracle error in dreii1fsh ORA-12899: value too large for column "DR$TOKEN" (actual: 69, maximum: 64)
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Wed, 4 Nov 2020 14:52:09 +0300
Message-ID: <CAOVevU4-zryMxnQD0vT6NZkCQMV0t+fJezDbjqqcyqc2Yd_CqA_at_mail.gmail.com>
Hi listers,
"TMDDBA"."DR$TM_CC_TC_ITEM_TXT_CAT$I"."DR$TOKEN" (actual: 69, maximum: 64)
Date: Wed, 4 Nov 2020 14:52:09 +0300
Message-ID: <CAOVevU4-zryMxnQD0vT6NZkCQMV0t+fJezDbjqqcyqc2Yd_CqA_at_mail.gmail.com>
Hi listers,
Does anybody know how to fix "ORA-12899: value too large for column
"DR$TOKEN" (actual: 69, maximum: 64)" after migrating from Oracle 12.2 to
Oracle 19?
Have you seen this exact error on CTX indexes before?
SQL> alter index tm_cc_tc_item_txt_cat rebuild;
alter index tm_cc_tc_item_txt_cat rebuild
*
ERROR at line 1:
ORA-29874: warning in the execution of ODCIINDEXALTER routine ORA-29960: line 1, DRG-50857: oracle error in dreii1fsh ORA-12899: value too large for column
"TMDDBA"."DR$TM_CC_TC_ITEM_TXT_CAT$I"."DR$TOKEN" (actual: 69, maximum: 64)
-- Best regards, Sayan Malakshinov Oracle performance tuning engineer Oracle ACE Associate http://orasql.org -- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 04 2020 - 12:52:09 CET