connecting to another DB as an alias

[jayjabour]

While connected to one db I want to compare the data in a table to the data in a table in another Db. How can I connect to another db as an alias. Both db's are 9i.

[davey23uk]

with a database link

[jayjabour]

Thanks I think I got it. For those interested in Db links but don't know how to create it (like I me) this sytax worked for me.
create database link dbname conect to schema name identified by pwd using 'link name';

[CENSUSDBA]

query this table
select * from dba_db_links


make certain the db_links is set properly.

[jayjabour]

here is a problem I am having. I have succsessfully created a few db links. I went to create another one using the same syntax and I get the following error ORA-02082 a loopback database link must have a connection qualifier. I can connect to the db using the schema name and pwd I am using in my create db statement. Here is the statement
create databse link PROD connect to sysdba identified by pwd using 'PROD';

[davey23uk]

well sysdba isnt a user and what is the tns entry for PROD