TESTING DATABASE LINKS FOR REPLICATION ORACLE 8I

[treedstang]

I trying to setup multimaster replication on oracle 8i 8.1.6. r2.

everything seem to fine until a get to the point creating and checking the database links

I ran the following command to test a link


connect user/password select * from dual@ttst.auaoe.com



D
-
X

SQL> exit

what to the D over the X represent???

[gsprince]

That is the column name "DUMMY" of the table "DUAL". Since it is of datatype VARCHAR2(1), is displaying just "D".

[jmodic]

It is the first character of the column name from the table DUAL you are selecting from (the only column that exists in that table): *D*ummy.

[treedstang]

Ok here's the problem with the links.

When I attempt to setup a replication group using the
Replication manager everytime I try add a site to replication group I get the following message

ORA-04054: database link TTST.AUAOE.COM DOES NOT EXIST

ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 3743
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 1901
ORA 06513: at "SYS.DBMS_REPCAT", line 121
ORA-06512: at line 2

So far I removed the catrep.sql and installed it and still no difference.
I checked metalinks website so far I'm unable any thing work reagarding the database links


I ran the following script to check and see if it the database link actually existed and everything appeared to have checked out

here's the script

select synonym_name,table_name,db_link from user _synonyms;


Any I ideas any one? Oh yeah I'm running oracle on Win2k Adv.


Thanks