Mar 30, 2006 #1 prosuc Programmer Aug 14, 2002 53 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 Jun 14, 2002 64 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 Aug 14, 2002 53 CL Thanks, Steve. I will test your idea. Upvote 0 Downvote