Re: Database link does not work with SQL Developer

On Mar 23, 10:44 pm, "antonyliu2..._at_yahoo.com" <antonyliu2..._at_yahoo.com> wrote:
> We access the university Enterprise Data Warehouse (we call it the
> EDW) through a database link named edwlink.
>
> We have no problem whatsoever using this edwlink with SQL*PLUS.
>
> Look:
>
> SQL> desc t_netid_at_edwlink;
> Name Null? Type
> ----------------------------------------- -------- ----------
>
> EDW_PERS_ID NOT NULL NUMBER(9)
> NETID_PRINCIPAL NOT NULL VARCHAR2(50)
> NETID_DOMAIN NOT NULL VARCHAR2(50)
> ENTRP_ID_IND NOT NULL VARCHAR2(1)
> NETID_EFF_DT NOT NULL DATE
> NETID_POST_DT NOT NULL DATE
>
> SQL>
>
> I just recently installed Oracle SQL Developer. Everything works fine
> with this SQL Developer except the database link.
>
> The same query you see above turns out to be an error in SQL
> Developer:
>
> ERROR: object T_NETID_at_EDWLINK does not exist.
>
> On the left of SQL Developer main window, there is a list of object
> categories. If I click on the heading "Database links", I can see
> that edwlink is listed there. And if I right-click on edwlink, and
> choose Test Database Link from the pop-up menu, and then hit Apply in
> the following dialog box, SQL Developer does say that the database
> link has been successfully tested.
>
> I googled, and hit this page:
>
> http://forums.oracle.com/forums/thread.jspa?messageID=1728549
>
> It looks like other people are having the same problem, and some
> replies say that the database link feature is simply missing in SQL
> Developer.
>
> But, if the feature is missing, then why "successfully test" it?
>
> Any solution to this problem?
>
> By the way, Toad for oracle applies this database link without any
> hassle.

oracle has dedicated a forum to address issues related to this...it is at:
http://forums.oracle.com/forums/forum.jspa?forumID=260

perhaps some response can be had from there.. Received on Sat Mar 24 2007 - 09:16:53 CDT