By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
- Create the database link to the remote database:
CREATE DATABASE LINK link_name CONNECT TO username IDENTIFIED BY password USING 'tns_alias';
- Create a trigger on the table which populates newly inserted rows into the remote database table.
CREATE TRIGGER my_table_insert_trig BEFORE INSERT ON my_table BEGIN INSERT INTO my_table@link_name VALUES (:new.colA, :new.colB, ..., :new.colX); END; /
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.