1 Reply Latest reply: Aug 5, 2004 8:04 AM by 358102 RSS

    ORA-04063

    ebimiere
      ORA-04063 : view "MDSYS.ALL_SDO_GEOM_METADATA" has errors

      How do I tackle that
        • 1. Re: ORA-04063
          358102
          Did you revoke any privileges (for example, role 'SELECT_CATALOG_ROLE') from the user 'MDSYS'?
          SQL> select * from dba_role_privs
            2  where grantee = 'MDSYS';
          
          GRANTEE                        GRANTED_ROLE                   ADM DEF
          ------------------------------ ------------------------------ --- ---
          MDSYS                          CONNECT                        NO  YES
          MDSYS                          RESOURCE                       NO  YES
          MDSYS                          SELECT_CATALOG_ROLE            NO  YES
          MDSYS                          EXECUTE_CATALOG_ROLE           NO  YES