Saturday, September 28, 2019

dblinks


set lines 100
set pages 100
column db_link format a40
column host format a100
select distinct owner from dba_db_links;
select OWNER,DB_LINK,CREATED from dba_db_links;
select OWNER,DB_LINK,CREATED,HOST from dba_db_links;
drop database link &n;



select Host,ACL from dba_network_acls;


find xx*  -type l | xargs ls –ltr

3 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. This comment has been removed by a blog administrator.

    ReplyDelete