2 Replies Latest reply on Mar 21, 2013 3:40 PM by 996752

    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.