OraFAQ Forum: Replication » Oracle 7 and Oracle 9i

Home » Server Options » Replication » Oracle 7 and Oracle 9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 7 and Oracle 9i [message #75528]

Fri, 30 July 2004 06:34

Giacomo Chimienti
Messages: 1
Registered: July 2004

Junior Member

Oracle 7 and Oracle 9i can to talk with dblink ?

Report message to a moderator

Re: Oracle 7 and Oracle 9i [message #75535 is a reply to message #75528]

Tue, 24 August 2004 23:49

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

No, you cannot:

SQL> CREATE DATABASE LINK ora7link CONNECT TO scott IDENTIFIED BY tiger
  2          USING 'orcl.world';

Database link created.

SQL>
SQL> SELECT * FROM dual@ora7link;
SELECT * FROM dual@ora7link
                   *
ERROR at line 1:
ORA-24439: Connections to Oracle7 server are no longer supported
ORA-02063: preceding line from ORA7LINK

Best regards.

Frank

Report message to a moderator

Re: Oracle 7 and Oracle 9i [message #75537 is a reply to message #75535]

Wed, 25 August 2004 13:13

Chanchal Kokkuvayil
Messages: 1
Registered: August 2004

Junior Member

Hi,

We also have a similar requirement in which we have to connect to an Oracle 7 database from Oracle 9i database.

Please let me know if you have found out any workarounds or any possible way to do this connection.

Its needed very urgenty.

Any help would be highly appretiated.

Thanks
Chanchal
chanchal.gopalakrishnan@emotors.com

Report message to a moderator

Re: Oracle 7 and Oracle 9i [message #75542 is a reply to message #75537]

Wed, 08 September 2004 12:10

Shaun Sprague
Messages: 2
Registered: September 2004

Junior Member

worked on it for weeks - appeals to Oracle OTN etc etc fell on deaf ears. Have ended up re-engineering the interface such that all scripts etc run from the Oracle 7 instance - which is allowed.

So data is nowpulled and pushed to the and from the 9i under the control of the 7.

A real pain!

Report message to a moderator

Re: Oracle 7 and Oracle 9i [message #75554 is a reply to message #75542]

Fri, 01 October 2004 04:20

Steve D
Messages: 1
Registered: October 2004

Junior Member

Try using an 8i 'stepping stone' database - link the 7 to 8, and then the 9 to 8. Build snapshots/views etc as necessary.

Note - just because on dbV9 you will be able to select * from tab@dbV8 which in turn is a synonym for select * from tab@dbV7 doesnt mean that you can create views/snapshots as easy !

Its a pain, but it is doable

Report message to a moderator

Previous Topic:	datebase link not active
Next Topic:	Database link active but could not be able to resolve object resolution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 22:57:39 CST 2024