Re: oracle 8i communicate with oracle 9i

Just create a regular database link
CREATE DATABASE LINK <link-name>

          CONNECT TO <username>
		 IDENTIFIED BY <password>
		         USING '<tns-name>';

But make sure that the server is in tnsnames.ora on your database server.

skyloon skrev:

> I'm planning to do data purging which transfer some old data in date
> range from oracle 8i to oracle 9i and then delete the old in oracle 8i.
> as i know, to communicate between database in same server, we need to
> use "Database Link"
> but if communicate with different server? any query or snytax to do it?
> or what steps i need to follow? Is it difficult to do it?
>
> Thanks..
Received on Tue Nov 28 2006 - 03:28:01 CST