ORA-31111: table string cannot be hierarchically enabled



ORA-31111: table string cannot be hierarchically enabled..

Answer / guest

Cause: Trigger <tabname>_xdb_pitrigger already exists

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-27052: unable to flush file data

1 Answers   Aomi,


TNS-00528: Protocol Adapter not loaded

1 Answers  


ORA-02776: Value for request done signal exceeds maximum

1 Answers  


ORA-25400: must replay fetch

1 Answers  


ORA-30118: syntax error at 'string' at the end of input

1 Answers  






ORA-03134: Connections to this server version are no longer supported.

1 Answers  


PCC-00143: Runtime context variable not of correct type

1 Answers  


ORA-27026: skgfrls: sbtend returned error

1 Answers  


ORA-09794: szrbuild: length of role name is greater than buffer.

1 Answers  


ORA-31033: Requested number of XML children string exceeds maximum string

1 Answers  


LPX-00226: entity "~S" is not declared

1 Answers  


ORA-30021: Operation not allowed on undo tablespace

1 Answers  


Categories