Redefinition主题的文章列表，还有Redefinition的技术要点_第2页

ORA-42001: online redefinition options require COMPATIBLE parameter to be string or greater

文档解释ORA-42001:onlineredefinitionoptionsrequireCOMPATIBLEparametertobestringorgreaterCause:Thefollowingtypesofredefinitionrequirea10.2orhighercompatibilitysettin...

IT技术学习 ·2023-07-09

ORA-42011: error occurred while completing the redefinition

文档解释ORA-42011:erroroccurredwhilecompletingtheredefinitionCause:Anerroroccurredwhilecompletingtheonlineredefinition.Action:Correcttheerrorandcontinuetheonlinered...

IT技术学习 ·2023-07-09

ORA-42006: dependent object registration not supported during a partition redefinition

文档解释ORA-42006:dependentobjectregistrationnotsupportedduringapartitionredefinitionCause:Anattemptwasmadetoregisterdependentobjectswhenredefiningapartition.Action...

IT技术学习 ·2023-07-09

ORA-42010: error occurred while synchronizing the redefinition

文档解释ORA-42010:erroroccurredwhilesynchronizingtheredefinitionCause:Anerroroccurredwhilesynchronizingtheonlineredefinitionwhichrequiresabortingtheredefinition.Act...

IT技术学习 ·2023-07-08

ORA-42003: partition must be specified for this redefinition

文档解释ORA-42003:partitionmustbespecifiedforthisredefinitionCause:Apartitionwasinvolvedinthisredefinitionbutwasnotspecified.Action:Specifythepartitioninvolvedinthi...

IT技术学习 ·2023-07-08

使用DBMS_REDEFINITION在线切换普通表到分区表

随着数据库数据量的不断增长，有些表须要由普通的堆表转换为分区表的模式。有几种不同的方法来对此进行操作。诸如导出表数据，然后创建分区表再导入数据到分区表。使用EXCHANGEPARTITION方式来转换为分区表以及使用DBMS_REDEFINITION来在线重定...

代码星球 ·2020-04-06