You are here: Home // Oracle 11g // ORA-14652: reference partitioning foreign key is not supported

ORA-14652: reference partitioning foreign key is not supported

Cause: The specified partitioning foreign key was not supported for reference-partitioned tables. All columns of the partitioning foreign key must be constrained NOT NULL with enabled, validated, and not deferrable constraints. Furthermore, a virtual column cannot be part of the partitioning foreign key. See the solution below.

Error solution: Correct the statement to specify a supported partitioning foreign key.

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: satel angielski dla dzieci Warszawa bmw strzyżenie damskie wrocław karuzele