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

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
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google