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

Last updated on MAY 30, 2019

Applies to:

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 upgrading to 11.2.0.4 using dbua with a home that has a PSU applied.

Cause

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