Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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.
![]() |
![]() |