RE: move some records of some tables

From: Robson, Peter <pgro_at_bgs.ac.uk>
Date: Tue, 03 Dec 2002 02:03:54 -0800
Message-ID: <F001.005107AC.20021203020354@fatcity.com>

There are issues here. Will the table being copied to have the same constraints in place as those tables from which the data is being extracted? If so, resolves those, and get these reference tables in place first.

Then simply use a database link to 'pull' the data from your source tables, eg

insert into USERNAME.COPY_TABLE select * from USERNAME.SOURCE_TABLE_at_DATABASE_LINK where....... ;

Of course, make sure the owner of the copy tables has select on the source tables.

peter
edinburgh

>
> 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).
>

---

This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please

scan all attachments.                            http://www.bgs.ac.uk
*********************************************************************

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robson, Peter
  INET: pgro_at_bgs.ac.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 Tue Dec 03 2002 - 04:03:54 CST