ORA-10640: Operation not permitted during SYSTEM tablespace migration ORACLE 报错 故障修复 远程处理

文档解释

ORA-10640: Operation not permitted during SYSTEM tablespace migration

Cause: SYSTEM tablespace is being migrated to locally managed format.

Action: Reissue this command once SYSTEM tablespace migration is over.

ORA-10640: Operation not permitted during SYSTEM tablespace migration 表示指定的操作是不允许的，因为系统正在进行SYSTEM表空间的迁移。

官方解释

ORA-10640 occurs when an operation is not permitted during a SYSTEM tablespace migration.

常见案例

ORA-10640 commonly occurs when performing an operation such as dropping a tablespace while migration of the SYSTEM tablespace is in progress. This error can also occur when attempting to upgrade databases from Oracle 10g (or earlier) to 11g (or higher).

正常处理方法及步骤

To resolve the ORA-10640 error, wait for the system migration to complete and then retry the operation. To speed-up the migration process for 10g or earlier to 11g or higher upgrade, you can use the “dbms_space_admin.migrate_system_tbs” command.