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-24348: Update or Delete without Where

1 Answers  


ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction

1 Answers  


NNF-04005: Cannot open inputfile

1 Answers  


ORA-19733: COMPATIBLE parameter needs to be string or greater

1 Answers  


ORA-26689: column datatype mismatch in LCR

1 Answers  






ORA-24197: JAVA stored procedure throws JAVA exceptions

1 Answers  


CLSS-00099: logfile open failed for string, err string

1 Answers  


ORA-12210: TNS:error in finding Navigator data

1 Answers  


ORA-21609: memory being resized without being allocated first

1 Answers  


ORA-01480: trailing null missing from STR bind value

1 Answers   IBM,


TNS-00031: INTCTL: internal NT error

1 Answers  


ORA-25449: invalid variable name: string

1 Answers  


Categories