问题描述
各位专家好，
是否可以将包含分区表的企业版本rman备份还原到标准版实例？
提前谢谢。
问候
纳比尔。
是否可以将包含分区表的企业版本rman备份还原到标准版实例？
提前谢谢。
问候
纳比尔。
专家解答
从文档中:
https://docs.oracle.com/en/database/oracle/oracle-database/21/upgrd/migrating-from-enterprise-to-standard-database.html#GUID-FD2DB65B-0E54-4ECE-8DF3-8E8F12FBD005
Converting from Enterprise Edition to Standard Edition requires exporting and importing data.
To properly convert from an Enterprise Edition database to a Standard Edition database, you must perform an Export/Import operation. Oracle recommends that you use the Standard Edition Export utility to export the data. If you only install Standard Edition software, then some data dictionary objects become invalid. These invalid objects create problems when maintaining the database.
The Export/Import operation does not introduce data dictionary objects specific to the Enterprise Edition, because the SYS schema objects are not exported. After the Import in the Standard Edition database, you are only required to drop user schemas related to Enterprise Edition features.
https://docs.oracle.com/en/database/oracle/oracle-database/21/upgrd/migrating-from-enterprise-to-standard-database.html#GUID-FD2DB65B-0E54-4ECE-8DF3-8E8F12FBD005
Converting from Enterprise Edition to Standard Edition requires exporting and importing data.
To properly convert from an Enterprise Edition database to a Standard Edition database, you must perform an Export/Import operation. Oracle recommends that you use the Standard Edition Export utility to export the data. If you only install Standard Edition software, then some data dictionary objects become invalid. These invalid objects create problems when maintaining the database.
The Export/Import operation does not introduce data dictionary objects specific to the Enterprise Edition, because the SYS schema objects are not exported. After the Import in the Standard Edition database, you are only required to drop user schemas related to Enterprise Edition features.
文章转载自ASKTOM，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
