Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: selecting database links in SQL*Plus
tim.bedford_at_ttplabtech.com (Tim) wrote in message 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
Tim, look in the Oracle version# Reference Manaul as this manual contains descriptions of all the dictionary tables.
Here is an online article:
How do I find information about a database object: table, index,
constraint, view, etc... in Oracle ?
http://www.jlcomp.demon.co.uk/faq/object_info.html