Oracle DBA, How To, Error, Cause and Action

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

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.

No comments:

Post a Comment

Thanks for your comment.