利用在线重定义功能将普通表转换为分区表问题

在运行过程中,发现以下错误

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;

 

然后重新运行正常

 

请使用浏览器的分享功能分享到微信等