views (materialize)

[ocpdude]

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,

[ocpdude]

anyone !!!!!!

[Sofiane]

Hello,

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

Sofiane

[omegamark]

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 .

[Peter Maloof]

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.