Database Error Messages

QSM-03282

A materialized view is registered on a table related to string.string.

Cause

The staging log creation on the specified table failed because a table related to it by referential-integrity constraint has a materialized view which was registered for synchronous refresh with the REGISTER_MVIEWS command. Oracle requires that you first register the tables before registering any materialized view defined on them.


Action

Unregister the materialized views defined on the related tables with the UNREGISTER_MVIEWS command. Then, register the tables with synchronous refresh by creating staging logs on them. Finally, register any materialized views you wish to register for synchronous refresh with REGISTER_MVIEWS.