By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.