ORA-12096: error in materialized view log on "string"."string"



ORA-12096: error in materialized view log on "string"."string"..

Answer / guest

Cause: There was an error originating from this materialized
view log. One possible cause is that schema redefinition has
occurred on the master table and one or more columns in the
log is now a different type than corresponding master
column(s). Another possible cause is that there is a problem
accessing the underlying materialized view log table.

Action: Check further error messages in stack for more
detail about the cause. If there has been schema
redefinition, drop the materialized view log and recreate it.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06202: Deleted string EXPIRED objects

1 Answers  


PLS-00587: a static method cannot be invoked on an instance value

1 Answers  


ORA-22057: bad integer length [string]

1 Answers  


ORA-14074: partition bound must collate higher than that of the last partition

1 Answers  


ORA-01679: database must be mounted EXCLUSIVE and not open to activate

1 Answers  






ORA-30513: cannot create system triggers of INSTEAD OF type

1 Answers  


ORA-02490: missing required file size in RESIZE clause

1 Answers  


ORA-10659: Segment being shrunk is not a lob

1 Answers  


QSM-02121: set operator in a context not supported for fast refresh

1 Answers  


RMAN-06066: the target database must be mounted when issuing a RECOVER command

1 Answers  


SQL*Loader-00132: invalid argument for external table option

1 Answers  


RMAN-08535: channel string: looking for autobackup on day: string

1 Answers  


Categories