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

LSX-00266: missing required attribute "~S"

1 Answers  


ORA-04043: object string does not exist

1 Answers  


ORA-31471: invalid OBJECT_ID value

1 Answers  


ORA-24777: use of non-migratable database link not allowed

1 Answers  


ORA-02159: installed DLM does not support releasable locking mode

1 Answers  


ORA-24029: operation not allowed on a single-consumer queue

1 Answers  


PCB-00576: PLS-number: string

1 Answers  


PLS-01458: The set clause in an UPDATE statement requires a column name of length 1

1 Answers  


ORA-33219: (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.

1 Answers  


NNC-00428: invalid meta-data data item

1 Answers  


NNL-00804: Queries received, type META-DATA: number

1 Answers  


PLS-00601: partition extended object names may only be used with tables

1 Answers  


Categories