Re: copy certain data from one database to another

why not use database link

create database link <link_name> for <user> identified by <pwd> using '<sid>';
insert into <table> * from <table>@<link_name> where id != id@<link_name>;

osy45

--
Posted via http://dbforums.com