pak vikas, sblm buat dblink antar 2 db oracle, buat dulu tnsnames dr db B ke db A. syntax utk buat dblink nya: 'create <public> database link (nama database link) connect to (nama user di db A) identified by (password user tsb) using '(tnsnames dr db B ke db A)';
jadi ntar create tablenya bisa pake syntax: 'create table (nama table baru) as select * from (nama table asal)@(nama dblink); cheers, [L] --- Vikas Anand <[EMAIL PROTECTED]> wrote: > Terima kasih atas jawabannya > > Pak, > Saya masih baru bagai mana cara buat Linknya dari > server a ke server b > pak... > > Terimakasih sebelumnya > > Regards > Vikas > > > On 9/20/06, Leonard Sukendro <[EMAIL PROTECTED]> > wrote: > > > > pak vikas, > > > > ini mo dipindah ato di copy gtu ya? > > klo mo dicopy, biasanya saya pake database link, > pak.. > > bikin database link dr server a ke server b, trus > copy > > kyak table biasa, > > contoh: create table b as select * from [EMAIL PROTECTED]; > > > > cheers, > > [L] > > > > --- Vikas Anand <[EMAIL PROTECTED]> wrote: > > > > > Pagi semua, > > > > > > Saya mau tanya ni saya masih baru di oracle > mohon > > > petunjuknya > > > > > > bagaimana saya memindahkan 1 table dari server a > ke > > > server b > > > > > > tolong querynya seperti apa ya..? > > > > > > sebelumnya terima kasih > > > > > > regards, > > > Vikas > > > > > > > > > [Non-text portions of this message have been > > > removed] > > > > > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around > > http://mail.yahoo.com > > > > > > -- > > -----------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 > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been > removed] > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- -----------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/ <*> 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: mailto:[EMAIL PROTECTED] mailto:[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/
