DBMS_MVIEW.REFRESH
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: DBMS_MVIEW.REFRESH

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    178

    Exclamation

    Dear ALL,

    I updated a table in a materialized view and tried to execute this procedure DBMS_MVIEW.REFRESH_DEPENDENT(super,'EMP',' ',FALSE,FALSE)
    but keep getting the following error messages:
    line 2, column 32:
    PLS-00201: identifier 'SUPER' must be declared
    ORA-06550: line 2, column 2:
    PL/SQL: Statement ignored

    Can anyone tell me how to resolve this or declare 'SUPER'

    AC

  2. #2
    the docs show that your variable super
    must be in of the type:
    { list IN VARCHAR2,
    | tab IN OUT DBMS_UTILITY.UNCL_ARRAY,}

    the uncl_array is also in the docs)...

    LIST AND TAB are mutually exclusive... if super is a list then it is a varchar so it must be in quotes.

    The dbms_mview.refresh is also an options if you like... you can refresh views that are invalid...

    select object_name, object_Type from user_objects where status = 'INVALID';

    note, the type is "UNKNOWN" for some reason.

    hope this helped.

  3. #3
    Join Date
    Nov 2000
    Posts
    178
    Thanks for the suggestion but it didn't work. I also querried the dba_view_analysis but the materialized view wasn't there. I think the materialized wasn't registered in the first place. Can you tell me why and if possible how to register it. The materialized view was created.

    The following parameters are needed to execute DBMS_MVIEW.REFRESH_DEPENDENT(failures, 'table_name','A','RBS002',FALSE,FALSE). What paramer do I need to supply in place of failures?.

    [Edited by ac on 06-03-2001 at 06:18 AM]

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