Berikut script untuk create materialized view : CREATE MATERIALIZED VIEW NAMA_MATERIALIZED_VIEW TABLESPACE NAMA_TABLESPACE NOCACHE LOGGING NOPARALLEL BUILD IMMEDIATE USING INDEX TABLESPACE NAMA_TABLESPACE REFRESH FAST ON DEMAND WITH ROWID AS SELECT field1, field2 FROM NAMA_TABLE
Regards, Defry --- On Wed, 3/25/09, Setijo Agus <[email protected]> wrote: From: Setijo Agus <[email protected]> Subject: Re: [indo-oracle] cara buat Materialized View To: [email protected] Date: Wednesday, March 25, 2009, 5:56 PM 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/materializ ed-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= > X3oDMTM2dmNjdjVr BF9TAzk3MzU5NzE0 BGdycElkAzMyMTMy MjUEZ3Jwc3BJZAMx > NzA1MDA3MTgzBG1z Z0lkAzE5OTkxBHNl YwNmdHIEc2xrA3Z0 cGMEc3RpbWUDMTIz > ODAwMTExMQR0cGNJ ZAMxOTk5MQ- -> > (1) Reply (via web post) > <http://groups. yahoo.com/ group/indo- oracle/post; _ylc=X3oDMTJxM2g > xMDB2BF9TAzk3MzU 5NzE0BGdycElkAzM yMTMyMjUEZ3Jwc3B JZAMxNzA1MDA3MTg > zBG1zZ0lkAzE5OTk xBHNlYwNmdHIEc2x rA3JwbHkEc3RpbWU DMTIzODAwMTExMQ- > -?act=reply& messageNum= 19991> > | Start a new topic > <http://groups. yahoo.com/ group/indo- oracle/post; _ylc=X3oDMTJlZjZ > nNXNuBF9TAzk3MzU 5NzE0BGdycElkAzM yMTMyMjUEZ3Jwc3B JZAMxNzA1MDA3MTg > zBHNlYwNmdHIEc2x rA250cGMEc3RpbWU DMTIzODAwMTExMQ- -> > > Messages > <http://groups. yahoo.com/ group/indo- oracle/messages; _ylc=X3oDMTJlN3J > mam1mBF9TAzk3MzU 5NzE0BGdycElkAzM yMTMyMjUEZ3Jwc3B JZAMxNzA1MDA3MTg > zBHNlYwNmdHIEc2x rA21zZ3MEc3RpbWU DMTIzODAwMTExMQ- -> > | Files > <http://groups. yahoo.com/ group/indo- oracle/files; _ylc=X3oDMTJmdmZ > vZTYzBF9TAzk3MzU 5NzE0BGdycElkAzM yMTMyMjUEZ3Jwc3B JZAMxNzA1MDA3MTg > zBHNlYwNmdHIEc2x rA2ZpbGVzBHN0aW1 lAzEyMzgwMDExMTE -> > | Photos > <http://groups. yahoo.com/ group/indo- oracle/photos; _ylc=X3oDMTJlajJ > ybjJvBF9TAzk3MzU 5NzE0BGdycElkAzM yMTMyMjUEZ3Jwc3B JZAMxNzA1MDA3MTg > zBHNlYwNmdHIEc2x rA3Bob3QEc3RpbWU DMTIzODAwMTExMQ- -> > > -- > -----------I. N.D.O - O.R.A.C.L.E- --------- ----- > Keluar: indo-oracle- unsubscribe@ yahoogroups. com > Website: http://indooracle. wordpress. com > http://www.facebook .com/group. php?gid=51973053 515 > ------------ --------- --------- --------- -------- > > 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=123800111192 1801/K=dGSbxdP87 6pK9DfXk6MkiQ/ A=5530388/ > R=0/SIG=11nuutla s/*http:/ /explore. yahoo.com/ groups/kraftmeal > smadesimple/> > > ------------ --------- --------- --------- --------- --------- - > 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=123800111192 1801/K=dGSbxdP87 6pK9DfXk6MkiQ/ A=5665377/ > R=0/SIG=12elk33s b/*http:/ /www.socialtrack .net/redir. aspx?CID= 11125&AFID= > 32673&DID= 50240&SID= Ad1%20> > > Yahoo! Groups > <http://groups. yahoo.com/ ;_ylc=X3oDMTJkZG 90MW5oBF9TAzk3Mz U5NzE0BGdycElkAz > MyMTMyMjUEZ3Jwc3 BJZAMxNzA1MDA3MT gzBHNlYwNmdHIEc2 xrA2dmcARzdGltZQ > MxMjM4MDAxMTEx> > > Change settings via the Web > <http://groups. yahoo.com/ group/indo- oracle/join; _ylc=X3oDMTJmMjJ > mNmwyBF9TAzk3MzU 5NzE0BGdycElkAzM yMTMyMjUEZ3Jwc3B JZAMxNzA1MDA3MTg > zBHNlYwNmdHIEc2x rA3N0bmdzBHN0aW1 lAzEyMzgwMDExMTE -> > (Yahoo! ID required) > Change settings via email: Switch delivery to Daily Digest > <mailto:indo-oracle- dig...@yahoogrou ps.com?subject=Email% 20Delivery: > %20Digest> > | Switch format to Traditional > <mailto:indo-oracle- traditional@ yahoogroups. com?subject=Change% > 20Delivery% 20Format: %20Traditional> > > Visit Your Group > <http://groups. yahoo.com/ group/indo- oracle;_ylc= X3oDMTJkOXBwYmhv > BF9TAzk3MzU5NzE0 BGdycElkAzMyMTMy MjUEZ3Jwc3BJZAMx NzA1MDA3MTgzBHNl > YwNmdHIEc2xrA2hw ZgRzdGltZQMxMjM4 MDAxMTEx> > | Yahoo! Groups Terms of Use <http://docs. yahoo.com/ info/terms/> | > Unsubscribe <mailto:indo-oracle- unsubscribe@ yahoogroups. com?subject=> > Recent Activity > > * > 34 > New Members > <http://groups. yahoo.com/ group/indo- oracle/members; _ylc=X3oDMTJmNXR > jM3FhBF9TAzk3MzU 5NzE0BGdycElkAzM yMTMyMjUEZ3Jwc3B JZAMxNzA1MDA3MTg > zBHNlYwN2dGwEc2x rA3ZtYnJzBHN0aW1 lAzEyMzgwMDExMTE -> > > Visit Your Group > <http://groups. yahoo.com/ group/indo- oracle;_ylc= X3oDMTJlNDBzZzE1 > BF9TAzk3MzU5NzE0 BGdycElkAzMyMTMy MjUEZ3Jwc3BJZAMx NzA1MDA3MTgzBHNl > YwN2dGwEc2xrA3Zn aHAEc3RpbWUDMTIz ODAwMTExMQ- -> > > 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=123800111192 1801/K=dGSbxdP87 6pK9DfXk6MkiQ/ A=5202316/ R=0/SIG=11aijbgh > b/*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=123800111192 1801/K=dGSbxdP87 6pK9DfXk6MkiQ/ A=5522130/ R=0/SIG=11k97shp > 3/*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=123800111192 1801/K=dGSbxdP87 6pK9DfXk6MkiQ/ A=5579900/ R=0/SIG=11o233dq > m/*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 ============ ========= ========= = [Non-text portions of this message have been removed]
