Home » Server Options » Replication » refresh_all_mviews returning failures but deferror is empty (Oracle 11.2.0.1)
refresh_all_mviews returning failures but deferror is empty [message #553682] Mon, 07 May 2012 17:40 Go to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
G'day,

I have successfully cleaned up our test environment but am having problems with the development environment.

We have a master table, a single materialized view log on that table, and 85 materialized views based on them.

Following is the output from my 'refresh_all_mviews' and query on 'deferror':
08:36:04 SQL> SET serverout ON
DECLARE
  v_failures NUMBER(12) := 0;
begin
  dbms_mview.refresh_all_mviews(v_failures,'F','', refresh_after_errors => true, atomic_refresh => false);
  dbms_output.put_line('Failures='||v_failures);
END;
/
08:36:33 SQL> 08:36:33   2  08:36:33   3  08:36:33   4  08:36:33   5  08:36:33   6  08:36:33   7  08
:36:33   8
Failures=5

PL/SQL procedure successfully completed.

08:36:47 SQL> 08:36:47 SQL> select * from deferror;

no rows selected

08:36:56 SQL>

Any ideas why no rows are being selected? Do I have to 'set' something 'on'?

David
Re: refresh_all_mviews returning failures but deferror is empty [message #555788 is a reply to message #553682] Tue, 29 May 2012 00:18 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
G'day,

I got an answer from Oracle for this one. Only updateable materialised views are displayed. Mine are not updateable therefore they do not appear.

David
Re: refresh_all_mviews returning failures but deferror is empty [message #555799 is a reply to message #555788] Tue, 29 May 2012 01:08 Go to previous message
Michel Cadot
Messages: 58632
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Previous Topic: Book on Materialized Views (3 Merged)
Next Topic: error ogg-00963
Goto Forum:
  


Current Time: Thu Jul 31 04:28:16 CDT 2014

Total time taken to generate the page: 0.06073 seconds