Question: I got an error message that said:
QSM-02077 materialized view log is newer than
last full refresh
What causes the QSM-02077 error?
Answer: The
oerr utility notes this for the QSM-02077 error:
QSM-02077 materialized view
log is newer than last full refresh
Cause: The capability in question is not
supported when the relevant materialized view log was created after
the creation or most recent complete refresh of the materialized
view.
Action: Perform a complete refresh of the
materialized view.
As you can see, your log is newer than the last full refresh.
I would drop and re-create the whole materialized view and make
sure that the log is created before that materialized view.
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
