Re: dbms_mview.refresh question

From: Joseph Li <lijoecyn_at_netspace.net.au>
Date: Wed, 18 Jul 2001 21:30:41 +1000
Message-ID: <9j3s77$1ooj$1@otis.netspace.net.au>

Hi, I have not used dbms_mview before. I had used Oracle 7.3 snapshot extensively. I had experienced all sorts of trouble refreshing a snapshot owned by a different Oracle user. So I just refreshed the snapshots regularly ( using the NEXT and INTERVAL parameters ) from the snapshots owner.

rgds
Joseph Li

"Rob K" <robkato_at_earthlink.net> wrote in message news:SF0%6.3331$ck5.359136_at_newsread2.prod.itd.earthlink.net...
> I have a procedure in dwp1 schema that executes
> the dbms_mview.refresh procedure.
> If I grant execute on that procedure and run the procedure from another
user
> I get the following errors.
>
> SQL> exec mview_refresh
> BEGIN mview_refresh; END;
>
> *
> ERROR at line 1:
> ORA-01403: no data found
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 1046
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 1028
> ORA-06512: at "DWP1.MVIEW_REFRESH", line 10
> ORA-06512: at line 1
>
> I don't get any errors if I run it under the dwp1 schema.
>
> Thanks Rob
>
>
Received on Wed Jul 18 2001 - 06:30:41 CDT