ORA-14706: multiple child tables reference constraint string in tablestring.

ORA-14706: multiple child tables reference constraint "string" in table "string"." string"

Cause:

An ALTER TABLE EXCHANGE [SUB]PARTITION CASCADE command found that the specified parent key in the specified table was referenced by partitioning constraints in multiple reference partitioned child tables.


Action:

Perform EXCHANGE [SUB]PARTITION without the CASCADE option. The CASCADE option is not supported if a parent key in the reference partitioned table hierarchy is referened by multiple partitioning constraints.

About