Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Posts
    4

    Unanswered: URGENT!!!!!!!!! DB LINK issues

    I have 2 instances. I want to view data in instance2, from instance1

    I am at instance1, and i try to execute this:
    select * from table@dblink2

    and i get ORA-02019, so i then i execute this on instance1:

    select * from all_db_links;

    Result:
    Owner Username DB_link Host
    PUBLIC|RHE |dblink2 |instance2|


    So, whats missing, there is a DB link created from instance1 to instance2, so why am i not able to view the data from instance2 ????

    Please respond ASAP......

  2. #2
    Join Date
    Jul 2003
    Location
    Near Paris France
    Posts
    60
    Don't forget TNSNAMES.ora

    Have you update it?

  3. #3
    Join Date
    Jul 2003
    Posts
    4

    Re: URGENT!!!!!!!!! DB LINK issues

    Originally posted by peak_amperes
    I have 2 instances. I want to view data in instance2, from instance1

    I am at instance1, and i try to execute this:
    select * from table@dblink2

    and i get ORA-02019, so i then i execute this on instance1:

    select * from all_db_links;

    Result:
    Owner Username DB_link Host
    PUBLIC|RHE |dblink2 |instance2|


    So, whats missing, there is a DB link created from instance1 to instance2, so why am i not able to view the data from instance2 ????

    Please respond ASAP......
    I have the Host and instance2, updated in my TNSNames.ora file, what else do i need to check???????

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    post your dblink create script.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Jul 2003
    Location
    Near Paris France
    Posts
    60
    I speak about Tnsname file on the server,
    not on your station

    have you postyour dblink?

Posting Permissions

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