Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011
    Location
    London
    Posts
    3

    Unanswered: Discoverer 11g and database links

    I've created a database link between 2 databases which is working fine via sqlplus. However when logged in to the Discoverer 11g Administrator GUI; all I'm presented with when adding folders to an existing business area is the default database; rather than the default database and the database links I've created.

    Does anyone know what's still to be set up so that all database links on a given database are displayed in this drop-down menu?

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by dkmfraser View Post
    Blah, blah, blah...
    Does anyone know what's still to be set up so that all database links on a given database are displayed in this drop-down menu?
    You will need to create "Views" for the tables from the remote db that you want to query.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jun 2011
    Location
    London
    Posts
    3
    the problem was solved by creating the database link on the right database...duh!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •