Mar 30, 2006 #1 prosuc Programmer Joined Aug 14, 2002 Messages 53 Location CL How can I connect 2 different databases via database triggers? DB1 = Oracle 9i Version 9.205 DB2 = Oracle 7.23 both databases are running above unix. DBLink doesn't work with those versions, and I want update differents tables between databases. Thanks.
How can I connect 2 different databases via database triggers? DB1 = Oracle 9i Version 9.205 DB2 = Oracle 7.23 both databases are running above unix. DBLink doesn't work with those versions, and I want update differents tables between databases. Thanks.
Mar 31, 2006 #2 slaing IS-IT--Management Joined Jun 14, 2002 Messages 64 Location GB Hello, The bad news is that Oracle doesn't offer connectivity between v7 and v9. Your best bet is to somehow use Oracle 8i as a go-between. One option might be to have an 8i listener serving these instances (are they on the same box ?) and use TNS entries that access that listener. Steve Upvote 0 Downvote
Hello, The bad news is that Oracle doesn't offer connectivity between v7 and v9. Your best bet is to somehow use Oracle 8i as a go-between. One option might be to have an 8i listener serving these instances (are they on the same box ?) and use TNS entries that access that listener. Steve
Mar 31, 2006 Thread starter #3 prosuc Programmer Joined Aug 14, 2002 Messages 53 Location CL Thanks, Steve. I will test your idea. Upvote 0 Downvote