ORA-30926: unable to get a stable set of rows in the source tables Cause: A stable set of rows could not be got because of large dml activity or a non-deterministic where clause. Action: Remove any non-deterministic where clauses and reissue the dml.
*Coba ganti* SQL> merge into site s 2 *using sitejbro j *3 on (s.site_id=j. site_id) SQL> merge into site s 2 using *(Select <sebutin_kolomnya> from sitejbro j)* 3 on (s.site_id=j. site_id) On 6/8/06, ade trisna <[EMAIL PROTECTED]> wrote: > > > > salam... > wah masih error juga nih... > > aqu mo merge data dari satu tabel ke tabel lain dan sudah semua kolom > source disebutkan > dengan struktur tabel yang sama dalam satu database > tapi masih error juga (tabel sitejbro ke tabel site). ada > yang punya solusi lain? thanx ya 4 solusinya > > > SQL> desc site > Name Null? Type > ------------ --------- --------- --------- -- -------- ------------ > --------- ------- > SITE_ID VARCHAR2(255) > SITE_NAME VARCHAR2(255) > LONGITUDE VARCHAR2(255) > LATITUDE VARCHAR2(255) > STREET VARCHAR2(255) > BUILDING VARCHAR2(255) > RT_RW VARCHAR2(255) > SUBDISTRICT VARCHAR2(255) > DISTRICT VARCHAR2(255) > CITY VARCHAR2(255) > POST_CODE VARCHAR2(255) > PROVINCE VARCHAR2(255) > REGION VARCHAR2(255) > BRANCH VARCHAR2(255) > REMARK VARCHAR2(255) > LASTUPDATE DATE > > SQL> desc sitejbro > Name Null? Type > ------------ --------- --------- --------- -- -------- ------------ > --------- ------- > SITE_ID VARCHAR2(255) > SITE_NAME VARCHAR2(255) > LONGITUDE VARCHAR2(255) > LATITUDE VARCHAR2(255) > STREET VARCHAR2(255) > BUILDING VARCHAR2(255) > RT_RW VARCHAR2(255) > SUBDISTRICT VARCHAR2(255) > DISTRICT VARCHAR2(255) > CITY VARCHAR2(255) > POST_CODE VARCHAR2(255) > PROVINCE VARCHAR2(255) > REGION VARCHAR2(255) > BRANCH VARCHAR2(255) > REMARK VARCHAR2(255) > LASTUPDATE DATE > > SQL> merge into site s > 2 using sitejbro j > 3 on (s.site_id=j. site_id) > 4 when matched then > 5 update set > 6 s.site_name= j.site_name, > 7 s.longitude= j.longitude, > 8 s.latitude=j. latitude, > 9 s.street=j.street, > 10 s.building=j. building, > 11 s.rt_rw=j.rt_ rw, > 12 s.subdistrict= j.subdistrict, > 13 s.district=j. district, > 14 s.city=j.city, > 15 s.post_code= j.post_code, > 16 s.province=j. province, > 17 s.region=j.region, > 18 s.branch=j.branch, > 19 s.remark=j.remark, > 20 s.lastupdate= j.lastupdate > 21 when not matched then > 22 insert values > 23 (j.site_id,j. site_name, j.longitude, j.latitude, j.street, j.building, > j.rt_rw,j. subdistrict, > 24 j.district,j. city,j.post_ code,j.province, j.region, j.branch, > j.remark, j.lastupdate) ; > using sitejbro j > * > ERROR at line 2: > ORA-30926: unable to get a stable set of rows in the source tables > > > salam, > > ade trisna > > > > untuk scriptnya sbb: > > > > ____________ _________ _________ _________ _________ __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail. yahoo.com > > > <!-- #ygrp-mlmsg {font:84.5% 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;} --> > > [Non-text portions of this message have been removed] > > > > <!-- #ygrp-mlmsg {font:84.5% 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;} --> > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Home is just a click away. Make Yahoo! your home page now. http://us.click.yahoo.com/DHchtC/3FxNAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
