DBMS_MVIEW.refresh error log
- From: "Xu, Roger" <Roger.Xu@xxxxxxxx>
- To: "Harel Safra" <harel.safra@xxxxxxxxx>
- Date: Wed, 1 Jul 2009 14:30:42 -0600
Thanks for the quick answer. Now I have a couple questions regarding
DBMS_MVIEW.refresh.
1) After I run DBMS_MVIEW.refresh('MY_MV', 'C') how do I know if
the MV is successfully refreshed? If it failed where do I see the error
message? We need to do this in a script run by crontab.
2) What happens while someone is viewing the readonly MV, the cron
job kicks in and starts a complete refresh?
Thanks,
Roger Xu
________________________________
From: Harel Safra [mailto:harel.safra@xxxxxxxxx]
Sent: Wednesday, July 01, 2009 3:18 PM
To: Xu, Roger
Cc: Oracle-L Group
Subject: Re: How do I list all materialized views in a refresh group?
You can query the DBA_REFRESH_CHILDREN view.
Harel Safra
Xu, Roger wrote:
There are dbms_refresh.add, dbms_refresh.subtract, etc. How come
there
is no dbms_refresh.list to list all the mviews in a refresh
group?
Thanks in advance. Roger
http://www.drpeppersnapplegroup.com/about/corporate to learn
more about Dr Pepper Snapple Group's commitment to corporate social
responsibility.
Please be conscious of the environment and print this email only
if absolutely necessary.
This e-mail (including any attachments) is confidential and may
contain privileged information of Dr Pepper Snapple Group, Inc. and/or
its subsidiaries ("Dr Pepper Snapple Group"). If you are not the
intended recipient or receive it in error, you may not use, distribute,
disclose or copy any of the information contained within it and it may
be unlawful to do so. If you are not the intended recipient, please
notify us immediately by returning this e-mail to us at
mailto:mailerror@xxxxxxxx and destroy all copies. Any views expressed by
individuals within this e-mail do not necessarily reflect the views of
Dr Pepper Snapple Group. This e-mail does not constitute a binding
offer, acceptance, amendment, waiver or other agreement, unless the
intent that an e-mail will constitute such is clearly stated in the body
of the email. Recipients are advised to subject this e-mail and
attachments to their own virus check
ing, in keeping with good computing practice. Please note that
e-mail r
eceived by Dr Pepper Snapple Group may be monitored in
accordance with applicable law.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » DBMS_MVIEW.refresh error log - Xu, Roger
