我可以使用 imp/exp 工具将数据库从 Oracle 9 迁移到 Oracle 10
我是分包商，我的客户想要将 Oracle 数据库从 9 升级到 10。其他供应商将执行升级过程，我被要求在升级之前创建所需的任何备份，然后在 Oracle 10 中重新创建环境。我的所有数据都存储在单个模式中的单独数据库中。没有花哨的关系、脚本或类似的东西（实际应用程序支持不同的数据库：Oracle、SQL Server、Postgres，因此我们希望避免任何特定于数据库的代码）。
我希望使用 imp/exp 但我不确定 imp/exp 是否向后兼容（exp 从 O9 和 imp 到 O10）？
如果有更好/推荐的方法来处理类似的情况，我将不胜感激。
I'm subcontractor and my client wants to upgrade Oracle database from 9 to 10. Other vendor is going to perform the upgrade process, and I was asked to create whatever backup I need before the upgrade, and then recreate the environment in Oracle 10. All my data is stored in a separate database in a single schema. No fancy relations, scripts or anything like this (actual app supports different dbs: Oracle, SQL Server, Postgres so we want to avoid any DB-specific code).
I was hoping to use imp/exp but I'm not sure if imp/exp are backward compatible (exp from O9 and imp to O10)?
If there is a better/recommended way of dealing with similar situation, I'll be grateful for any advice.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
是的，可以使用imp/exp来实现那个。当您使用 Oracle10 时，请使用 Oracle 的新数据泵 实用程序而不是 imp/exp。
Yes, you can use imp/exp to achieve that. And when you are on Oracle10, use Oracle's new Data Pump utilities instead of imp/exp.
您当然可以使用 exp 工具导出数据库，然后使用 imp 工具将其导入到新数据库。
有关此问题的更多信息，请查看导入导出常见问题解答。
You can for sure use the exp tool to export your database and then use the imp tool to import it to the new database.
For more information on this matter, take a look at Import Export FAQ.
虽然您可以使用 exp/imp 从旧版本“升级”，但我不会这样做！
通过使用 exp/imp 您可以有效地创建一个新数据库。您将丢失所有表统计信息。当然，您可以重新创建它们。但为什么？您还需要创建新的登录名/密码。确保不涉及用于查询数据库的第 3 方工具。也许与此同时，已经创建了第二个模式（例如，用于报告生成），该模式对“您的”应用程序表进行了授权。
我认为最好安装oracle 10软件，然后升级现有数据库。 Oracle提供了足够的迁移工具。
无论您选择哪条路，都应该使用全部“生产”数据在集成服务器上进行彻底测试。另请注意，导入时间可能比导出时间长得多。
While you can use exp/imp to "upgrade" from an older version, i wouldn't do it!
By using exp/imp you are effectively creating a new database. You are going to loose all table statistics. Sure, you can recreate them. But why? You will also need to create new logins/passwords. Make sure, that there are no 3-rd party tools involved, which are used for querying the database. Perhaps in the meantime, a second schema (eg. for report generation) has been created which has grants on "your" application tables.
In my opinion it would be better to install the oracle 10 software and then to upgrade the existing database. Oracle provides sufficient migration tools.
No matter what road you are choosing, you should test it throroughly on an intergration server using the full volume of the "production" data. Also be aware, that the import can take much much longer than the export did.