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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access