0

expdp数据库导出到低版本?

问题归档 2019-08-07
109
摘要:12c的数据库数据库能够导出然后导入到11G吗?

问题描述

12c的数据库数据库能够导出然后导入到11G吗?

专家解答

导出时直接指定version=11.2即可

On a Data Pump export, if you specify a database version that is older than the current database version, then a dump file set is created that you can import into that older version of the database. For example, if you are running Oracle Database 12c Release 1 (12.1.0.2) and specify VERSION=11.2 on an export, then the dump file set that is created can be imported into an Oracle 11.2 database.


If you specify a database release that is older than the current database release, then certain features may be unavailable. For example, specifying VERSION=10.1causes an error if data compression is also specified for the job because compression was not supported in Oracle Database 10g release 1 (10.1).


Data Pump Import can always read Data Pump dump file sets created by older releases of the database.


When operating across a network link, Data Pump requires that the source and target databases differ by no more than two versions. For example, if one database is Oracle Database 12c, then the other database must be 12c, 11g, or 10g. Note that Data Pump checks only the major version number (for example, 10g,11g, 12c), not specific release numbers (for example, 12.1,10.1, 10.2, 11.1, or 11.2).

「喜欢文章,快来给作者赞赏墨值吧」

评论

0
0
最新发布
暂无内容,敬请期待...
数据库资讯
最新 热门 更多
本月热门
近期活动
全部
暂无活动,敬请期待...
相关课程
全部
暂无课程,敬请期待...