A client is trying to rebuild an index online with the following errors:
SQL> alter index indx_cdr rebuild online;
alter index IDX_CDR rebuild online
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01450: maximum key length (3215) exceeded
SQL> select max(length( call_message)) from cdr;
MAX(LENGTH(CALL_MESSAGE))
-------------------------
3586
WORKAROUND
Build the index without ONLINE option:
SQL> alter index indx_cdr rebuild; Index altered.