Re: copy certain data from one database to another

If you have an account in both databases (the target and source) and in both databases, the account has the same password, then there is an implied database link and one does not need created.

In the target database, simply issue the command: insert into target_table select * from source_table_at_sid; commit;

If you don't have faith in this approach, create a dummy table and try the SQL out before doing it for real.

You can issue a query before hand to see if you are going to run into problems with primary keys.

Export/Import with a where clause is another option.

I suggest familiarizing yourself with Export/Import and database links. They are priceless tools. All it will set you back is a good hour and a half of reading....

Good Luck!

"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 Mon Feb 24 2003 - 16:43:50 CST