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

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

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;

 

然后重新运行正常

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-178097/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-178097/