- create database link ...
- insert into ... select from ...
- delete from ...
- commit
- drop database link ...
Cheers
Connor
- MURAT BALKAS <murat.balkas_at_o2.net.tr> wrote: >
Hi,
>
> what's the best method to move some rows of
> some tables of a user
> from one database to another database on another
> server? I need a step by
> step document to achieve this.
>
> Thanks,
> Murat
>
>
> --------------------------------------
> Bu e-posta sadece yukarida isimleri belirtilen
> kisiler arasinda ozel
> haberlesme amacini tasimaktadir. Size yanlislikla
> ulasmissa lutfen mesaji
> geri gonderiniz ve sisteminizden siliniz.
> Rt.Net Internet Hizmetleri
> Pazarlama ve Ticaret A.S. bu mesajin icerigi
> ile ilgili olarak hic bir
> hukuksal sorumlulugu kabul etmez.
>
> This e-mail communication is intended for the
> private use of the persons
> named above. If you received this message in
> error, please immediately
> notify the sender and delete it from your
> system. Rt.Net Internet
> Hizmetleri Pazarlama ve Ticaret A.S. does not
> accept legal responsibility
> for the contents of this message.
> --------------------------------------
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: MURAT BALKAS
> INET: murat.balkas_at_o2.net.tr
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Dec 02 2002 - 07:23:41 CST