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-19615: some files not found in backup set

1 Answers  


ORA-16121: applying transaction with commit SCN string

1 Answers  


SQL*Loader-00138: Invalid value for DATE_CACHE

1 Answers  


ORA-23435: cannot create an updatable ROWID materialized view with LOB columns

1 Answers  


PCB-00301: Use of non-ANSI function is an Oracle extension

1 Answers  






RMAN-06404: database dismounted

1 Answers  


RMAN-06472: channel id string is automatically allocated

1 Answers  


ORA-16109: failed to apply log data from previous primary

1 Answers  


ORA-37073: (XSMCSESS01) Applied relation workspace object must be dimensioned by dimension workspace object.

1 Answers  


ORA-01136: specified size of file string (string blocks) is less than original size of string blocks

1 Answers  


ORA-00036: maximum number of recursive SQL levels (string) exceeded

1 Answers  


ORA-39043: Object type string is not supported for string jobs.

1 Answers  


Categories