Index Rebuild Failed With ORA-14456: cannot rebuild index on a temporary table

advertisements

_____________________________________________________________________________________________________________________

Problem Description:

Index rebuild failed with following error.

SQL> ALTER INDEX IDX_TEMP_EMP REBUILD ONLINE;

ALTER INDEX IDX_TEMP_EMP REBUILD ONLINE

*

ERROR at line 1:

ORA-14456: cannot rebuild index on a temporary table

Error Description

Index on a temporary table cannot be rebuilt. You can check the table is temporary or not by using the following query. See an example given below.

SQL> create global temporary table temp_emp as select * from emp;

Table created.

SQL> select table_name, TEMPORARY from dba_tables where TABLE_NAME='TEMP_EMP';

TABLE_NAME                     T

------------------------------ -

TEMP_EMP                       Y

SQL> CREATE INDEX IDX_TEMP_EMP ON TEMP_EMP(EMP_NAME);

Index created.

SQL>

SQL> ALTER INDEX IDX_TEMP_EMP REBUILD ONLINE;

ALTER INDEX IDX_TEMP_EMP REBUILD ONLINE

*

ERROR at line 1:

ORA-14456: cannot rebuild index on a temporary table

_____________________________________________________________________________________________________________________

Website Stats