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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14314: resulting List partition(s) must contain atleast 1 value

1 Answers  


ORA-02702: osnoraenv: error translating orapop image name

1 Answers  


ORA-31624: operation string not allowed when job in string state

1 Answers  


ORA-15039: diskgroup not dropped

1 Answers  


NZE-28761: element creation failure

1 Answers  


ORA-09791: slembdf: translation error, unable to translate error file name.

1 Answers  


NNF-03004: DNS Class mismatch (string)

1 Answers  


PCC-00045: %s clause inappropriate at line number in file string. Ignored.

1 Answers  


ORA-26507: null master connection

1 Answers  


ORA-02236: invalid file name

1 Answers  


TNS-01081: Started with pid=string

1 Answers  


ORA-25182: feature not currently available for index-organized tables

1 Answers  


Categories