Today we are going to have look on the topic of the Rebuilding index. In this post we are going to learn why do we need rebuilding the index? It explains the steps we use to solve the error.
While we rebuild the index we face the problem.
06:19:09 [SYS][TEST]>> ALTER index TEST.IDX_NEW rebuild online; ALTER index TEST.IDX_NEW rebuild online * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01450: maximum key length (3215) exceeded
The issue was fixed with rebuilding the index without online.
06:24:30 [SYS][TEST]>> ALTER index TEST.IDX_NEW rebuild; Index altered.
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
Anuradha’s LinkedIn: Anuradha’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp