2 Replies Latest reply: Mar 21, 2013 10:40 AM by 996752 RSS

    What Privileges are needed to use extended schema URL


      Oracle documentation says "Privileged users can use such an extended URL to specify XML schemas belonging to other users."

      Does someone know that what Privileges are needed for user A to use a schema registered in user B's schema?

      I am trying to create a table as SYSDBA in user A's schema having an XMLTYPE column which uses the schema registered in user B's schema.
      I am getting error ERROR at line 1:
      ORA-00902: invalid datatype

      Any help is appreciated.