Re: copy certain data from one database to another

Hi!

Anyway, if you want to import to a table which already contains rows, you have to user ignore=y parameter with imp.

Tanel.

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:sj26a.54094$jM5.135912_at_newsfeeds.bigpond.com...
> 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 - 11:32:52 CST