How to fix the Oracle error ORA-39940: Child reference partitioned table string.string in tablespace string or parent table string.string in tablespace string is included but not both.?

In this post, you’ll learn more about the Oracle ErrorORA-39940: Child reference partitioned table string.string in tablespace string or parent table string.string in tablespace string is included but not both. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-39940: Child reference partitioned table string.string in tablespace string or parent table string.string in tablespace string is included but not both.

Reason for the Error ORA-39940: Child reference partitioned table string.string in tablespace string or parent table string.string in tablespace string is included but not both.

Informational message to describe a failure during transportable containment checking. Both parent and child reference partition tables must be included.

How to fix the Error ORA-39940: Child reference partitioned table string.string in tablespace string or parent table string.string in tablespace string is included but not both. ?

You can fix this error in Oracle by following the below steps

Check reference partitioned tables.