Re: selecting database links in SQL*Plus

From: Ban Spam <ban-spam_at_operamail.com>
Date: Thu, 20 Dec 2001 00:39:54 GMT
Message-ID: <Xns917CA98A77FE9SunnySD@24.0.3.73>

tim.bedford_at_ttplabtech.com (Tim) wrote in news:daf29ce0.0112190052.4b422b8b_at_posting.google.com:

> mark.powell_at_eds.com (Mark D Powell) wrote in message
> news:<178d2795.0112181331.62670c75_at_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 --

>
>
> Thanks Mark,
> Do you know any good web sites with this info? I've got several Oracle
> books and none of them mention that table.
> thanks,
>
> Tim
>

When I get desparate sometimes I'll do something similar to the following:

SELECT TABLE_NAME, COLUMN_NAME FROM DBA_COL_COMMENTS WHERE COLUMN_NAME LIKE '%LINK%'; Then start doing DESC on table which have "interesting" column_names. Typically Oracle supplied column_names are "reasonably" named.

HTH & YMMV HAND! Received on Wed Dec 19 2001 - 18:39:54 CST