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

ORA-19609: %s is from different backup set: stamp string count string

1 Answers  


ORA-02081: database link is not open

1 Answers  


ORA-32010: cannot find entry to delete in SPFILE

1 Answers  


NNO-00260: loading configuration data from checkpoint file "string"

1 Answers  


ORA-02446: CREATE TABLE ... AS SELECT failed - check constraint violated

1 Answers  






ORA-30369: maximum number of columns is 32

1 Answers  


ORA-19755: could not open change tracking file

1 Answers  


DRG-12406: invalid CTX EXEC tag attribute (string)

1 Answers  


ORA-12008: error in materialized view refresh path

1 Answers  


ORA-09967: scumnt: unable to create or open file

1 Answers  


NZE-28802: invalid mode or data source in configuration file

1 Answers  


DRG-11529: token exceeds maximum length

1 Answers  


Categories