Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: Refreshing Materialized View (DBMS_SNAPSHOT.REFRESH)

    I wish to refresh a materialzed view. There are several parameters that may be set when using the DBMS_SNAPSHOT.REFRESH procedure. I want to specify the materialized view name, the refresh method, and the parallelism parameter (4) while not setting amy of the other parameters.

    I have tried setting the parameters using the statement below but several error messages are generated.

    EXECUTE DBMS_SNAPSHOT.REFRESH (TEST_MV', '?', , , , ,4, , );

    Any idea how to proceed?

  2. #2
    Join Date
    Sep 2003
    Location
    India
    Posts
    6

    Re: Refreshing Materialized View (DBMS_SNAPSHOT.REFRESH)

    Try using '' for unused parameters.
    EXECUTE DBMS_SNAPSHOT.REFRESH (TEST_MV', '?','','','','' ,4,'','' );
    Also you can try using NULL as parameter without quotes.

    RM

Posting Permissions

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