Cannot compile package DBMS_MVIEW
I can describe the package just fine.
I cannot compile it.
Any ideas ?
PHP Code:
SQL> show user
USER is "SYS"
SQL> alter package sys.dbms_mview compile package;
alter package sys.dbms_mview compile package
*
ERROR at line 1:
ORA-04043: object DBMS_MVIEW does not exist
SQL> show user
USER is "SYS"
SQL> ALTER PACKAGE DBMS_MVIEW COMPILE PACKAGE;
ALTER PACKAGE DBMS_MVIEW COMPILE PACKAGE
*
ERROR at line 1:
ORA-04043: object DBMS_MVIEW does not exist
SQL> desc DBMS_MVIEW
SQL> desc DBMS_MVIEW
PROCEDURE BEGIN_TABLE_REORGANIZATION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TABOWNER VARCHAR2 IN
TABNAME VARCHAR2 IN
PROCEDURE DROP_SNAPSHOT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MOWNER VARCHAR2 IN
MASTER VARCHAR2 IN
SNAPSHOT DATE IN
...