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
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