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.
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.