My Oracle Support Banner

OHF 7.3 Install Fail With 'ORA-02449: unique/primary keys in table referenced by foreign keys' (Doc ID 2717956.1)

Last updated on OCTOBER 14, 2020

Applies to:

Oracle Healthcare Foundation - Version 7.3 and later
Information in this document applies to any platform.

Symptoms

Oracle Healthcare Foundation - Version 7.1.1 and later

When upgrading from OHF 7.1.1 to OHF 7.3, the following error occurs.

ERROR
-----------------------

*******************************************************************************************************************************
Line 857590: FAIL 159: 'ORA-02449: unique/primary keys in table referenced by foreign keys', Rule 'pragma err forever ^ORA-.*'
*******************************************************************************************************************************
  8 begin
  9 for curRec in cur loop
 10 -- execute immediate 'drop ' || curRec.object_type || ' "' || curRec.object_name || '"';
 11 execute immediate 'drop materialized view "' || curRec.object_name || '"';
 12 end loop;
 13 end;
 14 /
declare
*
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys
ORA-06512: at line 11
ORA-06512: at line 11



**********************************************************************************
Line 857591: FAIL 160: 'ORA-06512: at line 11', Rule 'pragma err forever ^ORA-.*'
**********************************************************************************
  9 for curRec in cur loop
 10 -- execute immediate 'drop ' || curRec.object_type || ' "' || curRec.object_name || '"';
 11 execute immediate 'drop materialized view "' || curRec.object_name || '"';
 12 end loop;
 13 end;
 14 /
declare
*
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys
ORA-06512: at line 11
ORA-06512: at line 11


SQL>

**********************************************************************************
Line 857592: FAIL 161: 'ORA-06512: at line 11', Rule 'pragma err forever ^ORA-.*'
**********************************************************************************
 10 -- execute immediate 'drop ' || curRec.object_type || ' "' || curRec.object_name || '"';
 11 execute immediate 'drop materialized view "' || curRec.object_name || '"';
 12 end loop;
 13 end;
 14 /
declare
*
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys
ORA-06512: at line

 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the installer
2. Error occurred.

 

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
References


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