利用線上重定義功能將普通錶轉換為分割槽表問題

在執行過程中,發現以下錯誤

ORA-12091: cannot online redefine table "TEST"."TB_LOG" with materialized views
ORA-06512: at "SYS.DBMS_REDEFINITION", line 8
ORA-06512: at "SYS.DBMS_REDEFINITION", line 247
ORA-06512: at line 2

ORA-12091 cannot online redefine table "string"."string" with materialized views

Cause: An attempt was made to online redefine a table that had materialized views defined on it or had a materialized view log defined on it or is a master.

Action: Drop all materialized views and materialized view logs before attempting to online redefine the table.

 

解決方法:

drop materialized view log on TB_LOG;

 

然後重新執行正常