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

TNS-00267: Navigator: Internal Error

1 Answers  


ORA-21301: not initialized in object mode

1 Answers  


NNO-00327: server statistic counter dump ends

1 Answers  


PCC-02372: FOR clause not allowed in SELECT statement

1 Answers  


ORA-12018: following error encountered during code generation for "string"."string"

1 Answers  






ORA-12064: invalid refresh sequence number: string

1 Answers  


RMAN-06190: PL/SQL package string.string version string in string database is not current

1 Answers  


RMAN-06067: RECOVER DATABASE required with a backup or created controlfile

1 Answers  


ORA-02175: invalid rollback segment name

1 Answers  


ORA-02456: The HASH IS column specification must be NUMBER(*,0)

1 Answers  


ORA-07501: scgtoa: $deq unexpected return

1 Answers  


ORA-25265: specified signature for a queue which does not support reciever non-repudiation

1 Answers  


Categories