Oracle 11g 与旧版 Oracle 的向后兼容性
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6200128/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle 11g Backward compatibility with older oracle releases
提问by Bhalchandra
Our organization is planning to upgrade its most of the oracle servers & clients to 11g Release 2.
我们的组织计划将其大部分 Oracle 服务器和客户端升级到 11g 第 2 版。
But one of our client system is still using oracle 8i installation.
但是我们的一个客户端系统仍然使用oracle 8i安装。
Can we able to access the objects of Oracle 8i from oracle 11g client?
我们可以从oracle 11g 客户端访问Oracle 8i 的对象吗？
Some blogs says that it should work and other say it won't.
一些博客说它应该有效，而另一些则说它不会。
Can anybody faced any issue with such configuration.
任何人都可以遇到这种配置的任何问题。
One of the senior dba told us that oracle only supports backward compatibility of 2 versions earlier to current version. Assuming this fact we shouldn't been able to access database objects running on oracle version 8.
一位资深 dba 告诉我们，oracle 只支持向下兼容 2 个早期版本到当前版本。假设这个事实，我们不应该能够访问在 oracle 8 上运行的数据库对象。
Kindly help.
请帮助。
Thanks in advance.
提前致谢。
回答by Brett
We had to revert to Oracle 10 client (10.1, I believe) in order to connect to an Oracle 8 database. If there is a way to do it using 11.2, I'd like to be schooled.
我们必须恢复到 Oracle 10 客户端（我相信是 10.1）才能连接到 Oracle 8 数据库。如果有办法使用 11.2 做到这一点，我想接受教育。
EDIT:10.2 will work. Here's the official word:
编辑：10.2 将工作。以下是官方说法：
http://www.oracle.com/technetwork/database/windows/install10202-083849.html
"Access to an Oracle Database Server (Oracle8i Release 3 or later)"
http://www.oracle.com/technetwork/database/windows/install10202-083849.html
“访问 Oracle 数据库服务器（Oracle8i 第 3 版或更高版本）”
And as of 11.1, you're out of luck:
从 11.1 开始，你就不走运了：
http://www.oracle.com/technetwork/database/windows/install11106-087844.html
"Access to an Oracle Database Server (Oracle9i Release 2 or later)"
http://www.oracle.com/technetwork/database/windows/install11106-087844.html
“访问 Oracle 数据库服务器（Oracle9i 第 2 版或更高版本）”
回答by Olaf
Oracle doesn't even list version 8 in any compatibility tables on their web site. We verified that current (11g R2) JDBC drivers from Oracle do not work with Oracle 8 database sources. It means that it is not possible to access Oracle 8 databases from the latest version of Oracle SQL Developer because it is using JDBC driver.
Oracle 甚至没有在其网站上的任何兼容性表中列出版本 8。我们验证了来自 Oracle 的当前 (11g R2) JDBC 驱动程序不适用于 Oracle 8 数据库源。这意味着无法从最新版本的 Oracle SQL Developer 访问 Oracle 8 数据库，因为它使用的是 JDBC 驱动程序。
While there is a slim chance to be able to access Oracle 8 from some other Oracle 11g client, I would not bet my business on that.
虽然能够从其他一些 Oracle 11g 客户端访问 Oracle 8 的机会很小，但我不会把我的生意押在这一点上。
回答by Gary Myers
Check out MyOracleSupport
查看 MyOracleSupport
Subject: Client / Server / Interoperability Support Between Different Oracle Versions Doc ID: 207303.1
主题：客户端/服务器/不同 Oracle 版本之间的互操作性支持文档 ID：207303.1
It won't go directly.
不会直接过去。
