oracle8 and 10g

ade336 · 07-26-2006, 11:55 PM

hi all....not sure this is the right place to asking bout oracle...can oracle8 and oracle10 connect each other...?i need to know...if can, how?....

vasudevadas · 07-31-2006, 05:09 PM

Yes I believe they can.

How? With a database link:

Code:

CREATE DATABASE LINK db_link_name CONNECT TO schema_name IDENTIFIED BY "password" USING 'database_sid'

The "database sid" is the database identifier found in the tnsnames.ora file.

ade336 · 08-01-2006, 04:11 AM

finnally i manage to counter the problem,just like u said using dblink..anyway thanks vasudevadas....what about sql?as i'm concern,both version cannot comunicate each other using database sql,but only sql from developer.!!correct me if i'm wrong.....thanks!