ORA-42001: online redefinition options require COMPATIBLE parameter to be string or greater
文档解释ORA-42001:onlineredefinitionoptionsrequireCOMPATIBLEparametertobestringorgreaterCause:Thefollowingtypesofredefinitionrequirea10.2orhighercompatibilitysettin...
ORA-42011: error occurred while completing the redefinition
文档解释ORA-42011:erroroccurredwhilecompletingtheredefinitionCause:Anerroroccurredwhilecompletingtheonlineredefinition.Action:Correcttheerrorandcontinuetheonlinered...
ORA-42006: dependent object registration not supported during a partition redefinition
文档解释ORA-42006:dependentobjectregistrationnotsupportedduringapartitionredefinitionCause:Anattemptwasmadetoregisterdependentobjectswhenredefiningapartition.Action...
ORA-42010: error occurred while synchronizing the redefinition
文档解释ORA-42010:erroroccurredwhilesynchronizingtheredefinitionCause:Anerroroccurredwhilesynchronizingtheonlineredefinitionwhichrequiresabortingtheredefinition.Act...
使用DBMS_REDEFINITION在线切换普通表到分区表
随着数据库数据量的不断增长，有些表须要由普通的堆表转换为分区表的模式。有几种不同的方法来对此进行操作。诸如导出表数据，然后创建分区表再导入数据到分区表。使用EXCHANGEPARTITION方式来转换为分区表以及使用DBMS_REDEFINITION来在线重定...
