|
Home > Archive > Other Oracle database topics > June 2005 > Refresh materialized view
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Refresh materialized view
|
|
| Alen Cappelletti 2005-06-09, 3:23 am |
| Hi all,
someone know as possible force refresh of MV by script?
I want to refresh when my trigger is on fire.
Thanks
Alen
| |
| Frank van Bortel 2005-06-09, 1:23 pm |
| Alen Cappelletti wrote:
> Hi all,
> someone know as possible force refresh of MV by script?
>
> I want to refresh when my trigger is on fire.
>
> Thanks
> Alen
>
What trigger? What version of Oracle? That latest ones
have the possibility to create a MV 'on commit refresh'.
--
Regards,
Frank van Bortel
| |
| Alen Cappelletti 2005-06-10, 3:23 am |
| Trigger is AFTER INSERT INTO TABLE....
oracle version is 8.1.7
I hope U can help me....
| |
| Frank van Bortel 2005-06-11, 3:23 am |
| Alen Cappelletti wrote:
> Trigger is AFTER INSERT INTO TABLE....
> oracle version is 8.1.7
>
> I hope U can help me....
>
No, no on commit refreshes in 817...
You could have a call to dbms_job, and submit a request for
a dbms_refresh.refresh - does refresh the snapshot group, not
just the snapshout (simple: add snapshot to gruop).
Not sure I like the solution, though - it my be very
resource demanding
--
Regards,
Frank van Bortel
| |
| William Robertson 2005-06-11, 8:23 pm |
| Frank van Bortel wrote:
> Alen Cappelletti wrote:
> No, no on commit refreshes in 817...
> You could have a call to dbms_job, and submit a request for
> a dbms_refresh.refresh - does refresh the snapshot group, not
> just the snapshout (simple: add snapshot to gruop).
>
> Not sure I like the solution, though - it my be very
> resource demanding
> --
> Regards,
> Frank van Bortel
Or for a single MV (or comma-separated list or DBMS_UTILITY.UNCL_ARRAY
collection), DBMS_MVIEW.REFRESH('mview list')
| |
| Frank van Bortel 2005-06-12, 7:23 am |
| William Robertson wrote:
>
> Or for a single MV (or comma-separated list or DBMS_UTILITY.UNCL_ARRAY
> collection), DBMS_MVIEW.REFRESH('mview list')
>
I was wondering about dbms_mview, and could not find it; assumed
it obsolete in 10g, without realizing it's a synonym for dbms_snapshot.
--
Regards,
Frank van Bortel
| |
| DA Morgan 2005-06-12, 1:23 pm |
| Frank van Bortel wrote:
> William Robertson wrote:
>
>
> I was wondering about dbms_mview, and could not find it; assumed
> it obsolete in 10g, without realizing it's a synonym for dbms_snapshot.
And the DBMS_MVIEW synonym is in 10gR1.
SQL> select object_name from dba_objects
2 where object_name = 'DBMS_MVIEW';
OBJECT_NAME
----------------------------------------
DBMS_MVIEW
SQL>
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)
|
|
|
|
|