Home » Server Options » Replication » Help to create MV
Help to create MV [message #143033] Tue, 18 October 2005 18:11 Go to next message
Messages: 2
Registered: October 2005
Junior Member

We are using Oracle 8.1.7

I have a doubt in rgds MV's .

Can any one please explain me the following

We have different tables, we are trying to create a views using
those tables (we need this for reporting)but it takes long time to run and display the data, so we thought of creating MV which will store data in a physical table where we can have some indiex and rest of other stuff , here are my Q's

1) How to start with MV , how to create MV

2) We want to that to refresh very frequently , how to do that , how it will refresh , do we need to schedule this from DBA side or we need to take care while creating MV.

Any other suggestion for first time MV creater.

Re: Help to create MV [message #144061 is a reply to message #143033] Mon, 24 October 2005 19:02 Go to previous message
Messages: 32
Registered: February 2005

Please find attached the details abt the creation of MV's on 8i

Hope this helps

  • Attachment: mv.txt
    (Size: 2.21KB, Downloaded 476 times)
Previous Topic: deftran queue in read only snapshot replication
Next Topic: ora-23319 Error ->parameter value proxy_repadmin is not appropriate
Goto Forum:

Current Time: Thu Aug 24 00:12:18 CDT 2017

Total time taken to generate the page: 0.05363 seconds