My Oracle Support Banner

Pol-5220 Foreign Key Error When Creating an FK using a Synonym as Reference (Doc ID 847131.1)

Last updated on APRIL 13, 2020

Applies to:

Oracle Lite - Version 10.0.0.0.1 and later
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
On 10.3.0.2.0 in Production:
When attempting to create a Foreign key the following error occurs:

ERROR
POL-5220 Foreign key error

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Install the mobile client.
2. Synchronize to create the olite DB.
3. Open an MSQL session and run the alter command to create the FK:

ALTER TABLE EMP ADD (CONSTRAINT FK_EMPDEPT FOREIGN KEY (DEPTNO) REFERENCES S_DEPT(DEPTNO));
POL-5220 Foreign key error





Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.