DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 21

Thread: Cannot compile package DBMS_MVIEW

Threaded View

  1. #1
    Join Date
    May 2005
    Posts
    129

    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"
    SQLalter package sys.dbms_mview compile package;
    alter package sys.dbms_mview compile package
    *
    ERROR at line 1:
    ORA-04043object 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-04043object 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

    ... 
    Last edited by marist89; 06-15-2005 at 04:29 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width