ORA-31097: Hierarchical Index not empty



ORA-31097: Hierarchical Index not empty..

Answer / guest

Cause: An attempt was made to rebuild the hierarchical index
which is not empty.

Action: Delete all rows in the hierarchical index and then
rebuild it.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00212: could not obtain enough memory to compile CASE statement

1 Answers  


ORA-31657: data filter name can not be defaulted

1 Answers  


ORA-08104: this index object string is being online built or rebuilt

1 Answers  


ORA-40225: model is currently in use by another process

1 Answers  


ORA-13774: insufficient privileges to select data from the workload repository

1 Answers  


PCC-00039: Unable to open input file "string"

1 Answers  


KUP-04071: record discarded from file string

1 Answers  


RMAN-04031: initialization parameters used for automatic instance: string

1 Answers  


O2U-00201: Illegal arguments to function o2upt()

1 Answers  


ORA-29843: indextype should support atleast one operator

1 Answers  


ORA-38493: feature not enabled : Expression Filter index

1 Answers  


QSM-02122: compatibility mode must be 8.1 or higher

1 Answers  


Categories