The first option involves creating a database link between the source and target databases, and then using the
insert command to only insert the rows and columns you require. Here is an example:
INSERT INTO emp (empid, ename, email) SELECT empid, ename, email FROM emp@remote_db WHERE ... ;
Your second option would be SQL*Loader. You would have to read the rows out of the source tables into a format that SQL*Loader could read, but you would then have the option of using SQL*Loader to insert into the target or to append if rows already existed. For more information about SQL*Loader, review theOracle Database 10g Release 2 Utilities (10.2).
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.