From 8i database schema owner with privileges 'create database link'

CREATE DATABASE LINK "XX" CONNECT TO "9idb_sch_owner" IDENTIFIED BY "*****" USING '8idb_to_9idb';

where 8idb_to_9idb is service name registered with 8i tnsnames.ora pointing to 9i database.

Replace the names withing quotes to the names relevant to your current exisiting database link.

If you want to find the details of the existing links, query the view dba_db_links.

I don't understand what you are saying:

Creating this link is part of your work schedule or not ? Am I missing something here ?

[Edited by sreddy on 07-08-2002 at 03:08 PM]