Mas Ario, Coba anda buat sebuah View yg isinya quary dari script anda, lalu baru anda buat materialized view dari view yg telah anda buat tsb. Regards, Antonius Bayu
----- Original Message ---- From: Ario Haris <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, November 21, 2007 8:56:31 AM Subject: Balasan: Re: [indo-oracle] how to create Materialized View from different database mas Bayu, scriptnya sudah saya perbaiki. tetapi tetap terjadi error ORA-32303: mviews with user-defined types cannot reference multiple master sites - maksud dari error diatas apa yah? - apakah mview bisa dibuat berdasarkan dua tabel yang berbeda dari dua database yang berbeda pula? Sebagai info saya ingin membuat mview yang menggabungkan tabel atribut biasa dan tabel spatial. Terima kasih Ario --- Antonius Bayu <[EMAIL PROTECTED] com> wrote: > Yg saya remark merupakan letak kesalahan dari script > view yg anda buat, > > > > CREATE MATERIALIZED VIEW TESTING_MV > > TABLESPACE USERS > > NOCACHE > > LOGGING > > NOCOMPRESS > > PARALLEL ( DEGREE DEFAULT INSTANCES DEFAULT ) > > BUILD IMMEDIATE > > USING INDEX > > TABLESPACE USERS > > REFRESH FAST > > WITH PRIMARY KEY > > AS > > select > > concat(concat( concat(a. kd_dept,a. kd_jur),a. > kd_kelas) > > id_kelas,a.kd_ dosen,a.tahun, b.kd_deptjur) --*****, > > > FROM admin.dept1@ db2 a, dept2 b > > where > > /*concat(*/ concat( a.kd_dept, a.kd_jur) > =b.kd_deptjur; > > > Regards, > Antonius Bayu > > > > > ----- Original Message ---- > From: Ario Haris <[EMAIL PROTECTED] co.id> > To: indo-oracle@ yahoogroups. com > Sent: Tuesday, November 20, 2007 10:07:27 PM > Subject: [indo-oracle] how to create Materialized > View from different database > > > > > > > > > > > > > > > Dear all, > > > > saya ingin bertanya tentang langkah2 membuat mview > > yang data-datanya berasal dari dua database berbeda. > > > > saya pernah coba dengan sintaks berikut: > > ============ ========= ========= ========= ==== > > > > CREATE MATERIALIZED VIEW TESTING_MV > > TABLESPACE USERS > > NOCACHE > > LOGGING > > NOCOMPRESS > > PARALLEL ( DEGREE DEFAULT INSTANCES DEFAULT ) > > BUILD IMMEDIATE > > USING INDEX > > TABLESPACE USERS > > REFRESH FAST > > WITH PRIMARY KEY > > AS > > select > > concat(concat( concat(a. kd_dept,a. kd_jur),a. > kd_kelas) > > id_kelas,a.kd_ dosen,a.tahun, b.kd_deptjur, > > FROM admin.dept1@ db2 a, dept2 b > > where > > concat(concat( a.kd_dept, a.kd_jur) =b.kd_deptjur; > > > > ============ ========= ========= ========= ========= > = > > namun terjadi error sebagai berikut > > > > ora-32303 : mviews with user-defined types cannot > > reference multiple master sites > > > > mohon petunjuk dari para master.. > > > > Terima kasih > > Ario > > > > ____________ _________ _________ _________ _________ > ________ > > Bergabunglah dengan orang-orang yang berwawasan, di > di bidang Anda! Kunjungi Yahoo! Answers saat ini > juga di http://id.answers. yahoo.com/ > > > > > > > > > > > > > <!-- > > #ygrp-mkp{ > border:1px solid > #d8d8d8;font- family:Arial; margin:14px > 0px;padding: 0px 14px;} > #ygrp-mkp hr{ > border:1px solid #d8d8d8;} > #ygrp-mkp #hd{ > color:#628c2a; font-size: 85%;font- weight:bold; line-height: 122%;margin: 10px > 0px;} > #ygrp-mkp #ads{ > margin-bottom: 10px;} > #ygrp-mkp .ad{ > padding:0 0;} > #ygrp-mkp .ad a{ > color:#0000ff; text-decoration: none;} > --> > > > > <!-- > > #ygrp-sponsor #ygrp-lc{ > font-family: Arial;} > #ygrp-sponsor #ygrp-lc #hd{ > margin:10px > 0px;font-weight: bold;font- size:78%; line-height: 122%;} > #ygrp-sponsor #ygrp-lc .ad{ > margin-bottom: 10px;padding: 0 0;} > --> > > > > === message truncated === ____________ _________ _________ _________ _________ ________ Bergabunglah dengan orang-orang yang berwawasan, di di bidang Anda! Kunjungi Yahoo! Answers saat ini juga di http://id.answers. yahoo.com/ <!-- #ygrp-mkp{ border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;} #ygrp-mkp hr{ border:1px solid #d8d8d8;} #ygrp-mkp #hd{ color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;} #ygrp-mkp #ads{ margin-bottom:10px;} #ygrp-mkp .ad{ padding:0 0;} #ygrp-mkp .ad a{ color:#0000ff;text-decoration:none;} --> <!-- #ygrp-sponsor #ygrp-lc{ font-family:Arial;} #ygrp-sponsor #ygrp-lc #hd{ margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;} #ygrp-sponsor #ygrp-lc .ad{ margin-bottom:10px;padding:0 0;} --> <!-- #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;} #ygrp-mlmsg table {font-size:inherit;font:100%;} #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height:1.22em;} #ygrp-text{ font-family:Georgia; } #ygrp-text p{ margin:0 0 1em 0;} #ygrp-tpmsgs{ font-family:Arial; clear:both;} #ygrp-vitnav{ padding-top:10px;font-family:Verdana;font-size:77%;margin:0;} #ygrp-vitnav a{ padding:0 1px;} #ygrp-actbar{ clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;} #ygrp-actbar .left{ float:left;white-space:nowrap;} .bld{font-weight:bold;} #ygrp-grft{ font-family:Verdana;font-size:77%;padding:15px 0;} #ygrp-ft{ font-family:verdana;font-size:77%;border-top:1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom:10px;} #ygrp-vital{ background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;} #ygrp-vital #vithd{ font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;} #ygrp-vital ul{ padding:0;margin:2px 0;} #ygrp-vital ul li{ list-style-type:none;clear:both;border:1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;} #ygrp-vital ul li .cat{ font-weight:bold;} #ygrp-vital a{ text-decoration:none;} #ygrp-vital a:hover{ text-decoration:underline;} #ygrp-sponsor #hd{ color:#999;font-size:77%;} #ygrp-sponsor #ov{ padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;} #ygrp-sponsor #ov ul{ padding:0 0 0 8px;margin:0;} #ygrp-sponsor #ov li{ list-style-type:square;padding:6px 0;font-size:77%;} #ygrp-sponsor #ov li a{ text-decoration:none;font-size:130%;} #ygrp-sponsor #nc{ background-color:#eee;margin-bottom:20px;padding:0 8px;} #ygrp-sponsor .ad{ padding:8px 0;} #ygrp-sponsor .ad #hd1{ font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;} #ygrp-sponsor .ad a{ text-decoration:none;} #ygrp-sponsor .ad a:hover{ text-decoration:underline;} #ygrp-sponsor .ad p{ margin:0;} o{font-size:0;} .MsoNormal{ margin:0 0 0 0;} #ygrp-text tt{ font-size:120%;} blockquote{margin:0 0 0 4px;} .replbq{margin:4;} --> ____________________________________________________________________________________ Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now. http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ [Non-text portions of this message have been removed]
