Re: move some records of some tables

Hello Murat

Export has a parameter Query that allow you to specify selection criteria for exporting a subset of records from the table. Import also has parameter Ignore=y and then the import ignore the error of the create table statement and append the imported records into an existing table.

So you can export the selected records only from your tables and import them to the seconds DB.

HTH Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, December 02, 2002 1:43 PM

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

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