ORA-02303 & ORA-00955 Errors on SYSTEM.LOGMNR$ Types During PSU Updates (Doc ID 2008146.1)

Last updated on AUGUST 23, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Oracle GoldenGate - Version 11.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

ORA-02303 "cannot drop or replace a type with type or table dependents" and ORA-00955 "name is already used by an existing object" errors can be seen on the following statements when upgrading an Oracle RDBMS to 11.2.0.4, e.g.

ORA-02303 "cannot drop or replace a type with type or table dependents"
create or replace type SYSTEM.LOGMNR$TAB_GG_REC wrapped
create or replace type SYSTEM.LOGMNR$COL_GG_REC wrapped
create or replace type SYSTEM.LOGMNR$SEQ_GG_REC wrapped
create or replace type SYSTEM.LOGMNR$KEY_GG_REC wrapped

ORA-00955 "name is already used by an existing object"
CREATE TYPE SYSTEM.LOGMNR$TAB_GG_RECS AS TABLE OF SYSTEM.LOGMNR$TAB_GG_REC;
CREATE TYPE SYSTEM.LOGMNR$COL_GG_RECS AS TABLE OF SYSTEM.LOGMNR$COL_GG_REC;
CREATE TYPE SYSTEM.LOGMNR$SEQ_GG_RECS AS TABLE OF SYSTEM.LOGMNR$SEQ_GG_REC;
CREATE TYPE SYSTEM.LOGMNR$KEY_GG_RECS AS TABLE OF SYSTEM.LOGMNR$KEY_GG_REC;

Changes

Database is being upgraded or a bundle patch is being applied.
The same could also manifest if you are for instance upgrading to 11.2.0.4 using dbua with a home that has a PSU applied.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms