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

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.

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

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

Hope this helps

Thanks
Vamshee
  • Attachment: mv.txt
    (Size: 2.21KB, Downloaded 2302 times)
Previous Topic: Replication in Oracle 9i
Next Topic: ora-23319 Error ->parameter value proxy_repadmin is not appropriate
Goto Forum:
  


Current Time: Thu Mar 28 04:36:42 CDT 2024