atina dwi palupi wrote: > > Teman, ada yang tahu gk... > saya bekerja sbg Outsource DBA Oracle di surabaya > tapi, masih awam banget ma Oracle(masih perlu banyak belajar) > Mo tanya, gimana cara bikin Materialized View? Ini masalahnya: > Bikin 2 User , user A dan user B. > di user A , ada tabel yang melakukan transaksi insert data > di user B, terdapat mview/Materialized View(konsep mview: dia bisa > update per satuan waktu, misal; 5 menitan) pada saat user A melakukan > insert data, user B bisa melihat data apa aja yang diinsert oleh A > pada 5 menit pertama(misalnya) > Tujuannya, database mo diakses dari kompi yg berbeda > > [Non-text portions of this message have been removed] > > __._,_.__
mungkin bisa dicoba test yang pernah saya buat di http://setijoagus.wordpress.com/2008/09/05/materialized-view/ http://setijoagus.wordpress.com/2008/09/09/basic-replication-master-view-materialized-view/ salam semoga bermanfaat. > _ > Messages in this topic > <http://groups.yahoo.com/group/indo-oracle/message/19991;_ylc=X3oDMTM2dmNjdjVrBF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBG1zZ0lkAzE5OTkxBHNlYwNmdHIEc2xrA3Z0cGMEc3RpbWUDMTIzODAwMTExMQR0cGNJZAMxOTk5MQ--> > > (1) Reply (via web post) > <http://groups.yahoo.com/group/indo-oracle/post;_ylc=X3oDMTJxM2gxMDB2BF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBG1zZ0lkAzE5OTkxBHNlYwNmdHIEc2xrA3JwbHkEc3RpbWUDMTIzODAwMTExMQ--?act=reply&messageNum=19991> > > | Start a new topic > <http://groups.yahoo.com/group/indo-oracle/post;_ylc=X3oDMTJlZjZnNXNuBF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTIzODAwMTExMQ--> > > > Messages > <http://groups.yahoo.com/group/indo-oracle/messages;_ylc=X3oDMTJlN3Jmam1mBF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA21zZ3MEc3RpbWUDMTIzODAwMTExMQ--> > > | Files > <http://groups.yahoo.com/group/indo-oracle/files;_ylc=X3oDMTJmdmZvZTYzBF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA2ZpbGVzBHN0aW1lAzEyMzgwMDExMTE-> > > | Photos > <http://groups.yahoo.com/group/indo-oracle/photos;_ylc=X3oDMTJlajJybjJvBF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA3Bob3QEc3RpbWUDMTIzODAwMTExMQ--> > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [email protected] > Website: http://indooracle.wordpress.com > http://www.facebook.com/group.php?gid=51973053515 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.com > MARKETPLACE > ------------------------------------------------------------------------ > From kitchen basics to easy recipes - join the Group from Kraft Foods > <http://us.ard.yahoo.com/SIG=14kr799tq/M=493064.12016295.13271503.10835568/D=groups/S=1705007183:MKP1/Y=YAHOO/EXP=1238008311/L=/B=WLPkTEPDhCs-/J=1238001111921801/K=dGSbxdP876pK9DfXk6MkiQ/A=5530388/R=0/SIG=11nuutlas/*http://explore.yahoo.com/groups/kraftmealsmadesimple/> > > > ------------------------------------------------------------------------ > What's your IQ score? Want to know how smart you really are? Find out > at Quizyou.net. > <http://us.ard.yahoo.com/SIG=14kfedhup/M=730914.13354441.13465017.10835568/D=groups/S=1705007183:MKP1/Y=YAHOO/EXP=1238008311/L=/B=WbPkTEPDhCs-/J=1238001111921801/K=dGSbxdP876pK9DfXk6MkiQ/A=5665377/R=0/SIG=12elk33sb/*http://www.socialtrack.net/redir.aspx?CID=11125&AFID=32673&DID=50240&SID=Ad1%20> > > > Yahoo! Groups > <http://groups.yahoo.com/;_ylc=X3oDMTJkZG90MW5oBF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMjM4MDAxMTEx> > > > Change settings via the Web > <http://groups.yahoo.com/group/indo-oracle/join;_ylc=X3oDMTJmMjJmNmwyBF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyMzgwMDExMTE-> > > (Yahoo! ID required) > Change settings via email: Switch delivery to Daily Digest > <mailto:[email protected]?subject=email%20delivery:%20Digest> > > | Switch format to Traditional > <mailto:[email protected]?subject=change%20delivery%20format:%20Traditional> > > > Visit Your Group > <http://groups.yahoo.com/group/indo-oracle;_ylc=X3oDMTJkOXBwYmhvBF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjM4MDAxMTEx> > > | Yahoo! Groups Terms of Use <http://docs.yahoo.com/info/terms/> | > Unsubscribe <mailto:[email protected]?subject=> > Recent Activity > > * > 34 > New Members > > <http://groups.yahoo.com/group/indo-oracle/members;_ylc=X3oDMTJmNXRjM3FhBF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzEyMzgwMDExMTE-> > > Visit Your Group > <http://groups.yahoo.com/group/indo-oracle;_ylc=X3oDMTJlNDBzZzE1BF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTIzODAwMTExMQ--> > > > 10 Day Club > > on Yahoo! Groups > <http://us.ard.yahoo.com/SIG=14h2d7qm2/M=493064.12016283.12445687.8674578/D=groups/S=1705007183:NC/Y=YAHOO/EXP=1238008311/L=/B=WrPkTEPDhCs-/J=1238001111921801/K=dGSbxdP876pK9DfXk6MkiQ/A=5202316/R=0/SIG=11aijbghb/*http://new.groups.yahoo.com/allbrangroup> > > Share the benefits > > of a high fiber diet. > > Yahoo! Groups > > Dogs Owners Group > <http://us.ard.yahoo.com/SIG=14hhn6pj3/M=493064.12016263.12445670.8674578/D=groups/S=1705007183:NC/Y=YAHOO/EXP=1238008311/L=/B=W7PkTEPDhCs-/J=1238001111921801/K=dGSbxdP876pK9DfXk6MkiQ/A=5522130/R=0/SIG=11k97shp3/*http://advision.webevents.yahoo.com/domorefordogs/> > > Join Do More For Dogs > > pet community > > Group Charity > > Give a laptop > <http://us.ard.yahoo.com/SIG=14h1qpifc/M=493064.12016306.12445698.8674578/D=groups/S=1705007183:NC/Y=YAHOO/EXP=1238008311/L=/B=XLPkTEPDhCs-/J=1238001111921801/K=dGSbxdP876pK9DfXk6MkiQ/A=5579900/R=0/SIG=11o233dqm/*http://www.amazon.com/b/ref=yahoogroups?node=721521011> > > Get a laptop: One > > laptop per child > > . > > -- =============================== gold jewelry manufacture UBSGOLD.COM UNIVERSE OF GOLD UNTUNG BERSAMA SEJAHTERA ===============================
