set serveroutput on;

DECLARE

       CURSOR obj_cur IS SELECT OBJECT_TYPE, OBJECT_NAME FROM ALL_OBJECTS WHERE  STATUS (more…)

CREATE DATABASE LINK “service_ID@db_LOC”
CONNECT TO “USERNAME” IDENTIFIED BY “Password!”
USING ‘(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=crs-hostname-scan)(PORT=1715)))
(CONNECT_DATA=(SERVICE_NAME=serviceid_RW))
)’; (more…)