SELECT * FROM "RSAFEXAYH"."T_PT_LEAVE";
select * from T_PT_LEAVE@DBLINK
select * from dba_db_links;
drop public database link dblink;
grant create public database link to RSAFEMASTER_XA
create public database link DBLINK
connect to rsafexayh identified by rsafexayh
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.145)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)';
select * from T_PT_LEAVE@DBLINK
select * from dba_db_links;
drop public database link dblink;
grant create public database link to RSAFEMASTER_XA
create public database link DBLINK
connect to rsafexayh identified by rsafexayh
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.145)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)';