Wednesday, April 20, 2016

ORA-01920 and ORA-02303 error occurs while running catmgdidcode.sql script

ORA-01920 and ORA-02303 error occurs while running catmgdidcode.sql script

Error:

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:
The schema created by the script was already in existence.
This is evident from the error messages

Solution:

Use this workaround for this issue.

1. Run this script (this drops the MGDSYS)

@?/md/admin/catnomgdidcode.sql
2. Then run the below script:

@?/md/admin/catmgdidcode.sql

Reference metalink Doc ID 1544490.1

No comments:

Post a Comment