Index rebuild failed with error message (ora-06502, ora-20112)
What is the possible cause for the following error when I 'rebuild index'? Is it index corrupt? But I check index status from dba_indexes but them are all 'valid'. Should I check with application team since ora-20112 indicate 'user level error'? Run out of solution.
(I try from script&command line, same error msg)
On Windows:
sql>ALTER INDEX prod.index1 rebuild nologging;
ALTER INDEX prod.index1 rebuild nologging
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20112: permission denied
ORA-06512: at line 4
On Linux:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> ALTER INDEX Prod.index_for_table_1 REBUILD nologging;
ALTER INDEX Prod.index_for_table_1 REBUILD nologging
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 2