Create Database Link

CREATE DATABASE LINK prd
CONNECT AS userid
IDENTIFIED BY password
USING ‘tns:name’;
DELETE table;
INSERT INTO table
SELECT * FROM table@prd;
DROP DATABASE LINK prd;
COMMIT;