-
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???
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|