Re: selecting database links in SQL*Plus

From: Tim <tim.bedford_at_ttplabtech.com>
Date: 19 Dec 2001 00:52:36 -0800
Message-ID: <daf29ce0.0112190052.4b422b8b@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 Received on Wed Dec 19 2001 - 02:52:36 CST