Re: need a report of all dblinks, any sugestions?

wrote:
>
> Dblinks have got out of control!! and I desperatly
> need to track them down.
> The ideal will be to have a report that shows the source and the target.

you can select columns you need from following view: DBA_DB_LINKS:

 SELECT OWNER,USERNAME,HOST
   FROM DBA_DB_LINKS;

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Assistant MIS Manager                Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049