Refreshing Materialized Views

From: Linda Miller Coker <tazmacc_at_yahoo.com>
Date: Fri, 16 Jun 2000 07:32:16 -0700 (PDT)
Message-Id: <10530.109549@fatcity.com>

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. Received on Fri Jun 16 2000 - 09:32:16 CDT