create database link tq84_to_10101010
connect to rene identified by supersecretpassword
using '(DESCRIPTION=(ADDRESS= (PROTOCOL=tcp) (Host=10.10.10.10) (Port=1521)) (CONNECT_DATA=(service_name=svc_10)))';
begin
dbms_utility.exec_ddl_statement@tq84_to_10101010(q'[
create view tq84_dblink_info as
select
sys_context('userenv', 'dblink_info') val
from
dual
]');
end;
/
Selecting from the view on the local database via the database link ‥