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.
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright ? 1996 - 2012
All rights reserved.
Oracle ?
is the registered trademark of Oracle Corporation.
|
|
