DB LINK
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: DB LINK

  1. #1
    Join Date
    Feb 2001
    Posts
    15
    Hi, friends. i created a db link using:

    Server SP:
    Oracle 8.0.5 standard
    GLOBAL_NAME = IRIS.WORLD
    DB_NAME = IRIS
    DB_DOMAIN = WORLD
    IRISCT is im my tnsnames.ora

    CREATE PUBLIC DATABASE LINK IRISCT
    CONNECT TO SYSTEM IDENTIFIED BY xxxx
    USING 'IRISCT';

    Server MG:

    ORACLE 8.1.6 ENTERPRISE
    GLOBAL_NAME = ORACLE
    INSTANCE_NAME = IRISCT
    DB_NAME = IRISCT
    DB_DOMAIN = ´´

    the db link created in SERVER MG works well and the other not.. can You help me???


  2. #2
    Join Date
    Feb 2001
    Posts
    15
    from the server sp:

    SQL> select *
    2 from teste@irisct;
    select *
    *
    ERRO na linha 1:
    ORA-03113: fim de arquivo no canal de comunicação

    but the server mg:


    SQL> select bomcod
    2 from bomitens@iris.world
    3 where rownum < 5;

    BOMCOD
    -------------------------
    1001
    1002
    1003
    1004

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    See this thread helps

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=7071[/url]
    Reddy,Sam

Posting Permissions

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



Click Here to Expand Forum to Full Width