ORA-01920 and ORA-02303 error occurs while running catmgdidcode.sql script (Doc ID 1544490.1)

Last updated on AUGUST 03, 2016

Applies to:

Oracle Applications Technology Stack - Version 12.0.6 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.

Symptoms

When running the $ORACLE_HOME/md/admin/catmgdidcode.sql the following errors are encountered:

CREATE USER mgdsys IDENTIFIED by mgdsys
  *
ERROR at line 1:
ORA-01920: user name 'MGDSYS' conflicts with another user or role name



CREATE OR REPLACE TYPE MGD_IDCOMPONENT TIMESTAMP '2005-05-26:10:23:10' OID 'F805ACEFD7883DD1E030578CBB054A48' wrapped
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents


No errors.
CREATE OR REPLACE TYPE MGD_IDCOMPONENT TIMESTAMP '2005-05-26:10:23:10' OID 'F805ACEFD7883DD1E030578CBB054A48' wrapped
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents

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