Kejadiannya sih rada aneh.. boleh tahu ini OS-nya apa? terus parameter init.ora GLOBAL_NAMES nilainya apa?
Kalau global_names=true, bisakah dicoba diset ke false dari session. Jadi sebelum jalankan sql insert, lakukan alter session set global_names=false; regards, tomi --- cyuniart <[EMAIL PROTECTED]> wrote: > mas heri dan mas henri, > dblink sudah ada, grant dan synonym yg diperlukan > juga sudah dibuat.. > > dari B(X) saya jalankan perintah 'select * from > test_v' sukses. > begitu juga saat 'insert into test2_v select * from > test' juga sukses. > > (note : test_v = view ke database Y > test2_v = view ke database Z > test = tabel milik B(X)) > > view test_v dan test2_v milik user A(X) > (note : dblink tidak public, view hanya di grant > select, insert, > update, delete ke B(X)). > > jadi user B(X) ini hanya sebagai penghubung > transaksi dari 2 db yg > berbeda. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Check out the new improvements in Yahoo! Groups email. http://us.click.yahoo.com/6pRQfA/fOaOAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.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/
