Oracle 9i client connectivity to Oracle 7.1.4

Hi All,

I created a DBLINK on a 9i server to a 7.1.4 server. CREATE DATABASE LINK my_link CONNECT TO rem_user IDENTIFIED BY rem_pwd USING 'my_tnsentry';

• But when I query through the link using "select max(t_date) from table1_at_mylink;", I get the following error: select max(t_date) from table1_at_mylink * ERROR at line 1: ORA-24439: Connections to Oracle7 server are no longer supported ORA-02063: preceding line from MY_LINK

When I connect using SQLPLUS, I get a similar error as above: /export/home/mmmm> sqlplus rem_user/rem_pwd_at_my_tnsentry

SQL*Plus: Release 9.2.0.2.0 - Production on Mon Oct 13 17:15:42 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-24439: Connections to Oracle7 server are no longer supported

Enter user-name:

How do I query a remote Oracle 7 database from Oracle 9i? My queries will run from a stored procedure in the 9i database.

Thanks in advance Received on Tue Oct 14 2003 - 18:09:02 CEST