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-23603: STREAMS enqueue aborted due to low SGA

1 Answers  


ORA-22313: cannot use two versions of the same type "string"

1 Answers  


ORA-12502: TNS:listener received no CONNECT_DATA from client

1 Answers  


RMAN-08002: starting full resync of recovery catalog

1 Answers  


DRG-10581: indirect datastores cannot be used with long or lob text columns

1 Answers  


ORA-00343: too many errors, log member closed

1 Answers  


ORA-01103: database name 'string' in controlfile is not 'string'

4 Answers  


ORA-01051: deferred rpc buffer format invalid

1 Answers  


ORA-13519: Database id (string) exists in the workload repository

1 Answers  


LSX-00258: invalid escape character

1 Answers  


ORA-08278: Cannot get CPU statistics

1 Answers  


NNO-00328: server has reset statistic counters to zero

1 Answers  


Categories