This discussion is archived
1 Reply Latest reply: Aug 5, 2004 6:04 AM by 358102 RSS

ORA-04063

ebimiere Newbie
Currently Being Moderated
ORA-04063 : view "MDSYS.ALL_SDO_GEOM_METADATA" has errors

How do I tackle that
  • 1. Re: ORA-04063
    358102 Newbie
    Currently Being Moderated
    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