cklinks.sql

REM *************************************************************************** 
REM 
REM        TITLE:
REM        AUTHOR:
REM        DESCRIPTION:
REM
REM
REM
REM        USAGE W/ PARAMETERS:
REM        
REM        TABLES USED:
REM
REM  MODIFICATION ALLOWED (Y/N):	
REM  MODIFICATION HISTORY:
REM  WHO          WHEN         WHAT
REM  --------------------------------------------------------------------------
REM               MM/DD/YY     INITIAL CREATION
REM
REM ***************************************************************************
REM ******************************************************
REM * ROUTINE:          cklinks.sql 
REM * DESCRIPTION:      Script obtains DB links info. 
REM *                   ( DBA_DB_LINKS )
REM *
REM * AUTHOR:           John Burrows
REM *
REM *****************************************************

set linesize 160 
set pagesize 60
set echo off;
set verify off;


COLUMN owner    FORMAT A12	
COLUMN db_link  FORMAT A30	
COLUMN host     FORMAT A30
COLUMN created  FORMAT A12	
COLUMN username FORMAT A10 

PROMPT
PROMPT **** CHECK DB LINKS ****
PROMPT
 

ACCEPT lowner PROMPT 'Enter the desired DB LINK OWNER:' ;
 
SELECT   db_link, 
	 owner,
	 host,
	 created, 
         username 
  FROM   sys.DBA_DB_LINKS 
  WHERE  owner LIKE '%&&lowner%' 
ORDER BY db_link, owner  ;

undefine lowner;