-
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,
-
-
Hello,
Reply to question 3 : I think that you have only to recompile the view.
Sofiane
Sofiane
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|