Re: copy certain data from one database to another

Hi David,

This is a general comment and suggestion to both yourself and anyone else intending to post a question here.

Oracle as a product has changed dramatically over the years and from release to release can offer different solutions to "general" questions such as yours. What may be impossible in one version maybe dead easy in another, what might be highly recommended in one version, might be terribly inefficient in another, what might be ..., oh you get the drift.

Without providing at least an Oracle version number, suggestions such as using the "QUERY" option with export may not be of much use. Then again it might be, I don't know ?

Another possible option is to simply use a database link and insert the relevant rows directly or to a holding table to clean out duplicate problems.

What happens with duplicates depends entirely on how you have configured constraints on the table and which solution you eventually think most appropriate.

Cheers

Richard

"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 - 06:53:16 CST