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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).