set serveroutput on;
DECLARE
CURSOR obj_cur IS SELECT OBJECT_TYPE, OBJECT_NAME FROM ALL_OBJECTS WHERE STATUS (more…)
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…)