Re: copy certain data from one database to another

From: John <john_at_1startdepot.com>
Date: Sun, 23 Feb 2003 09:41:14 -0800
Message-ID: <DGAx$J22CHA.341@newsgroup.korea.com>

This can easily be done using DBScripter for Oracle (www.dkgas.com).

If you can create a select statement for the rows you need, DBScripter will convert the output into insert statements which can then be run in your second database.

John

"David Nguyen" <nguyend4_at_hotmail.com> wrote in message news:9a0092d.0302222156.15773f7b_at_posting.google.com...
> Hi All,
>
> I have another challenge need to ask:
>
> I want to copy (or EXP/IMP) 50 rows of data from one table of 1000
> rows from one database to another DATABASE same table structure but
> already contain data 500 rows.
>
> I don't know if it can be done. If it can what happen if some of the
> rows is duplicates?
>
> Thanks in advance
>
> DAVID
Received on Sun Feb 23 2003 - 11:41:14 CST