views (materialize)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: views (materialize)

  1. #1
    Join Date
    Nov 2000
    Posts
    198

    Question

    Hi,
    I have couple of questions about views..

    1) how can I refresh a view ???
    2) is it better to have materialize view rather than regular view????

    3) my views are based on remote tables..I've done an IMP/EXP(update 805 to 816)... do I need to recreate my views ???

    thanks,

  2. #2
    Join Date
    Nov 2000
    Posts
    198
    anyone !!!!!!

  3. #3
    Join Date
    Sep 2000
    Posts
    64
    Hello,

    Reply to question 3 : I think that you have only to recompile the view.

    Sofiane
    Sofiane

  4. #4
    Join Date
    Sep 2000
    Posts
    384
    1) how can I refresh a view ???

    You can do this recreating the view by create or replace view ...

    2) is it better to have materialize view rather than regular view????

    Materailized views are used in dss applications mostly and for aggregate function like sum,average,min,max, for performance gain.

    This depands upon your application and size of the tables .

    Radhakrishnan.M

  5. #5
    Join Date
    Jun 2000
    Posts
    7
    1) how can I refresh a view ???

    DBMS_MVIEW.REFRESH

    See the Oracle8i Data Warehousing Guide, chapter 8, "Materialized Views" and chapter 14 "Loading and Refreshing".

    Hope this helps.

    Peter

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