Results 1 to 4 of 4
  1. #1
    Join Date
    May 2011

    Unanswered: Connection for Remote database lost

    I am using oracle and I tried to select tables from another database by using the general syntax
    Select dbms_column name from schema_name.table_name@db_link;
    but I somehow got this error
    ORA-02019: connection description for remote database not found.I typed in the right schema name and database link.
    By the way the remote database is using oracle 10 g. Will this affect my sql execution??...

    Thank you in advance


  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 4
    When using a database link, you don't need schema name. It means that
    select empno from emp@db_link
    is all you need.

    Also, did you verify that the database link is OK? The simplest way is to
    select * from dual@db_link
    If it returns a record, database link is working OK. Otherwise, you didn't create it properly.

    Finally, error description:
    Quote Originally Posted by Oracle
    ORA-02019: connection description for remote database not found

    Cause: An attempt was made to connect or log in to a remote database using a connection description that could not be found.

    Action: Specify an existing database link. Query the data dictionary to see all existing database links. See your operating system-specific Net8 documentation for valid connection descriptors.

  3. #3
    Join Date
    Jun 2004
    Liverpool, NY USA
    Is the connection setup for the other database in the tnsnames.ora file for 11G database?
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    May 2011
    Thank you Little foot my database link is not OK so I need to configure it..

    @Beilswh-thank you for you time I did not have a connection set up yet..

Posting Permissions

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