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@mylink;", I get the following error:
select max(t_date) from table1@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@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