Re: selecting database links in SQL*Plus

From: Mark D Powell <mark.powell_at_eds.com>
Date: 18 Dec 2001 13:31:15 -0800
Message-ID: <178d2795.0112181331.62670c75@posting.google.com>

tim.bedford_at_ttplabtech.com (Tim) wrote in message news:<daf29ce0.0112180202.6f616f19_at_posting.google.com>...
> Hi,
>
> How can I list all the database for a schema? ie whats the equivalent of:
>
> SELECT TABLE_NAME FROM USER_TABLES;
>
> ..for database links?
>
> thanks,
>
> Tim

UT1> desc user_db_links

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DB_LINK                                   NOT NULL VARCHAR2(128)
 USERNAME                                           VARCHAR2(30)
 PASSWORD                                           VARCHAR2(30)
 HOST                                               VARCHAR2(2000)
 CREATED                                   NOT NULL DATE

Naturally there is a dba_db_links also.

Mark D Powell --

Received on Tue Dec 18 2001 - 15:31:15 CST