pertama harus ada dblink dari db_b ke db_a dan menggunakan user di db_a yang
bisa select ke table yang di tuju.
kalau sudah ada dblink tinggal jalankan query di db_b untuk insert, yang
biasa saya pake seperti ini :
begin
begin
insert /*+ BYPASS_RECURSIVE_CHECK */
into table_di_dba_b
select *
from table_di_d...@nama_dblink
exception
when others then
rollback;
end;
commit;
end;
ini yang biasa saya pake.
2009/12/22 Hanafi <[email protected]>
>
>
> HI Indo-Oracle,
> Apakah bisa (jika Iya, ada sample-nya) Select dan Subquery (Insert) dengan
> Berbeda Database?
>
> Misal Query DB_A dan di Insert ke DB_B?
>
> Thanks.
>
> Salam,
> Hanafi.
>
> [Non-text portions of this message have been removed]
>
>
>
--
silahkan kunjungi alamat berikut :
http://irvan.site90.net
http://www.suzuki-2wheels.or.id/forum
[Non-text portions of this message have been removed]
------------------------------------
--
-----------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.comYahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indo-oracle/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> 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/
