Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem viewing a database link through SQL

Status
Not open for further replies.
ManxDom

ManxDom

Programmer
Aug 7, 2002
22
GB
There is an Oracle database link set up on one of our servers which I need to see. Have been unable to do so. Does anyone know how, or if this can be done? Dom
 
Sort by date Sort by votes
You can view db links by logging in as a user and selecting from user_db_links or logging in as sys and system and selecting from all_db_links.
flstf
 
Upvote 0 Downvote
Thanks, that is just what I was after.
Appreciated. Dom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
725
Andrzejek
Andrzejek
hipath4k
  • Locked
  • Question
Share link to download Orcale 10 G
Replies
0
Views
155
hipath4k
hipath4k
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp
unixfreak
  • Locked
  • Question
sqlplus backspace through 'screen'
Replies
1
Views
179
Samthyr
Samthyr
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
605
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top