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/
 


Kirim email ke