ORA-01450 Error Encoutered on Index Rebuild Online

Encountered a weird error today when I was rebuilding an unsable index.

ORA-01450: maximum key length (3215) exceeded

Apparently rebuilding indexes online uses up additional data blocks (double the size?), but if db_block_size is too small, then it will fail with error above.

The index can still be rebuilt but we have to omit the online clause:

Use: Alter index {index_name} rebuild;

Instead of: Alter index {index_name} rebuild online;

Refer to metalink Note:136158.1: ORA-01450 and Maximum Key Length – How it is Calculated.

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

About Jimbart