Create database link

Create database link.

Last updated: 19 September 2016

Warning: Review and test in a non-production environment before running.

Back to results

drop public database link "TO_REMOTE_DB";

create public database link "TO_REMOTE_DB" connect to APP_USER identified by "********" using 'REMOTE_DB';

SELECT COUNT(*) FROM user_tables@TO_REMOTE_DB;