Multiversion Interoperability
Oracle permits database links between any two RDBMS versions between Version 6 and Version 8, inclusive. However, there are restrictions, particularly when a Version 6 database is involved.
For database links going from an Oracle Version 6 database to an Oracle7 database:
Comparisons of fixed-length strings use blank-padded semantics in the Oracle7 database, even though Oracle Version 6 itself does not.
The link must be over a SQL*Net V2 connection if the Oracle Version is 7.3 or higher.
From an Oracle7 or Oracle8 database to an Oracle Version 6 database:
The database link must be over a SQL*Net V2 or Net8 connection.
The link can update only a single Version 6 database in a given statement.
The link cannot perform distributed transactions with an Oracle Version 6 database.
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
