Results 1 to 2 of 2

Thread: DB Help!!!!!

  1. #1
    Join Date
    Jul 2003
    Posts
    4

    Unanswered: DB Help!!!!!

    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
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Try setting the:

    GLOBAL_NAMES=FALSE

    parameter on both initSID1.ora and initSID2.ora files and re-start the instances.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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