SELECT * FROM my_table WHERE deptno=15;I can then create a database link to the other database and then insert data in to a table in the other database link as follows:
INSERT INTO remote_table@remote_db SELCT * FROM my_table WHERE deptno=15;You can also use this with the export and import utilities. Create a dump file containing the records from the table:
exp userid=scott tables=emp file=emp.dmp where='deptno=15'Then import the dump file into the other database.
This was first published in March 2007