OTN Discussion Forums : Database Links

Reply to this Thread

Search Forum

Back to Thread List

Replies: 3 - Pages: 1 - Last Post: Mar 8, 2007 11:53 PM Last Post By: -K-

charles.griswold

Posts: 4
Registered: 07/09/01

Database Links - Objects Unviewable
Posted: Mar 8, 2007 5:46 AM

Oracle SQL Developer 1.1 Patch 2

When I connect to a database with my schema, I can see all my objects in the database, however, when I try looking at objects that I have access to in a different database through a database link...no objects show up. The database links are present in the database that I am connecting too, but I am unable to view other objects that I have access to through the database link? Is this a bug or do I not have the connection setup correctly?

-K-

Posts: 4,070
Registered: 10/24/01

Re: Database Links - Objects Unviewable
Posted: Mar 8, 2007 6:20 AM

in response to: charles.griswold

If you mean being able to see remote objects amongst the local ones, I'd say that's a missing feature you can request at the SQL Developer Exchange.

K.

thefurryone

Posts: 966
Registered: 02/11/07

Re: Database Links - Objects Unviewable
Posted: Mar 8, 2007 2:41 PM

in response to: -K-

The best that you can get with the current functionality is to list the synonyms you have for the objects across the database link, assuming that you have created synonyms.

-K-

Posts: 4,070
Registered: 10/24/01

Re: Database Links - Objects Unviewable
Posted: Mar 8, 2007 11:53 PM

in response to: thefurryone

Creating synonyms for the remote objects in the schema you want them to appear would make a great workaround, nice one furry!

K.

Pages: 1

Back to Thread List

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)