ORA-12091: cannot online redefine table “%s”.”%s” with materialized views

ORA-12091: cannot online redefine table “%s”.”%s” with materialized views

​​cannot online redefine table “TEST”.”T” with materialized views [oracle@solaris ~]oerr ora 12091 12091, 00000, “cannot online redefine table /”%s/”./”%s/” 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. // 先abort，然后在重新start，这里多半是已经start过了。所以已经有了materialized view log了 可以drop materialized view log on tablename,或者直接abort_redef_table SQL> exec dbms_redefinition.abort_redef_table(’TEST’,'T’,'T_NEW’); PL/SQL procedure successfully completed.

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。