| ERROR | materialized view log on string.string is in an inconsistent state |
| CAUSE | There was an error while creating the materialized view log and the log is currently in an inconsistent state. A possible cause could be that schema redefinition has occurred on the master table while the log was being created. Another possible cause could be that there were DMLs being applied on the master table concurrently in another session at the time the materialized view log creation started and those DML transactions havent committed even after a very long period of time. |
| ACTION | Drop the materialized view log and recreate it. ///////////////////////////////////////////////////////////////////////////// 23600-23999 Reserved for Log Based Replication PL/SQL packages ///////////////////////////////////////////////////////////////////////////// |