ORA-01450
Tried to rebuild an index online, but it failed with ORA-01450.
SQL> alter index user1.index1 rebuild online;
alter index user1.index1 rebuild online
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01450: maximum key length (3215) exceeded
It seems that the column we want to build on exceeds the limit of 4000 characters. Let's check the data length of the table.
SQL> select max(length(COL1)) max_length from USER1.TABLE1;
MAX_LENGTH
----------
26
As we can see, the result shows that even the maximum data length of the column does not exceed the limit. To solve ORA-01450, we choose a more conservative way to rebuild the index.
SQL> alter index user1.index1 rebuild online;
Index altered.
We rebuilt it without ONLINE and it succeeded.