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-14085: partitioned table cannot have column with LONG datatype

1 Answers  


ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.

1 Answers  


ORA-01611: thread number string is invalid - must be between 1 and string

1 Answers  


ORA-07587: spdcr: $CREPRC failure

1 Answers  


ORA-03129: the next piece to be inserted is required

1 Answers  


QSM-01070: equivalence class manager was not found

1 Answers  


TNS-04204: Trace Assistant Internal ERROR: Couldn't Open trace file

1 Answers  


NNL-00579: _scan: find objects/records matching the given types

1 Answers  


ORA-02220: invalid MINEXTENTS storage option value

1 Answers  


ORA-36883: (XSSRF02) The first parameter of an AW single row function cannot be NULL.

1 Answers  


ORA-02168: invalid value for FREELISTS

1 Answers  


ORA-01252: cannot prevent writes - file string in recovery manager backup

1 Answers  


Categories