RE: Refreshing Materialized Views

From: Miller, Jay <JayMiller_at_TDWaterhouse.com>
Date: Tue, 20 Jun 2000 16:33:46 -0400
Message-Id: <10534.109912@fatcity.com>

It may be related to a problem I had where I could not refresh more than one view at a time (the dictionary would show that it was refreshed but it would not be used). Running dbms_mview.refresh for each materialized view individually worked. Since I only have two mviews I didn't bother looking into it any further.

Do you still have the problem if you refresh the views individually? If not, you could use some dynamic sql to generate the commands.

-----Original Message-----
From: Linda Miller Coker [mailto:tazmacc_at_yahoo.com] Sent: Friday, June 16, 2000 11:42 AM
To: Multiple recipients of list ORACLE-L Subject: Refreshing Materialized Views

I have had this TAR open for almost a month and Oracle can't seem to figure out what is going on. It looks like it refreshes but my views are empty. Any ideas?

18-MAY-00 15:57:12 GMT New info : I ran two different ways, but my views are now empty.

  SQL> declarefal number;
  2 begin
DBMS_SNAPSHOT.REFRESH_ALL_MVIEWS(fal,'A','r02', FALSE,TRUE);
  3 end;
  4 /

PL/SQL procedure successfully completed.

  SQL>declare fal number;
  2 begin
DBMS_mview.REFRESH_ALL_MVIEWS(fal,'A','r02',FALSE, TRUE);
  3 end;
  4 /

PL/SQL procedure successfully completed.

Thank You for Your Business,
Linda Miller-Coker
Click here to view my auctions:
<A HREF=http://auctions.yahoo.com/booth/tazmacc><IMG SRC=http://auctions.us.yimg.com/banner.gif></A>

Do You Yahoo!?
Send instant messages with Yahoo! Messenger. http://im.yahoo.com/

-- 
Author: Linda Miller Coker
  INET: tazmacc_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jun 20 2000 - 15:33:46 CDT