ORA-22933 - When creating synonym for sys.xmltype on Database 11g (Doc ID 1302647.1)

Last updated on FEBRUARY 04, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Version: 11.1.0.6 11.2.0.2 and later
[Release: 11.1 to 11.2 and later]


Symptoms

When trying to create synonym in a user scheme for SYS.XMLTYPE the following error comes:

SQL> create synonym XMLTYPE for sys.XMLTYPE;
create synonym XMLTYPE for sys.XMLTYPE
*
ERROR at line 1:
ORA-22933: cannot change object with type or table dependents

Changes

After upgrade to 11g can not create synonym for sys.xmltype while there is a public synonym for it.


SQL> conn test/t
Connected.
SQL> create synonym XMLTYPE for sys.XMLTYPE;
create synonym XMLTYPE for sys.XMLTYPE
*
ERROR at line 1:
ORA-22933: cannot change object with type or table dependents


Tested the same statement on 10.2.0.4:


SQL> conn test/t
SQL> create synonym XMLTYPE for sys.XMLTYPE;

Synonym created.


==========================================================
Also The issue does not reproduce for a user defined-type on both 10g and 11g:


SQL> conn / as sysdba

SQL> create type test_type as table of varchar2(10);
/

Type created.

SQL> create public synonym test_type for test_type;

Synonym created.

SQL> conn test/t
Connected.
SQL> create synonym test_type for sys.test_type;

Synonym created.

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