It would be very simple to write a stored procedure to do the refresh and write a record. It could also note if there were any error messages on the refresh.



-----Original Message-----
From: Martin Rosol
[mailto:oracledba-ezmlmshield-x1718805.[Email address protected]
Sent: Friday, March 31, 2006 12:16 PM
To: LazyDBA Discussion
Subject: Database triggers after materialized view refresh?


Using Oracle 10g Release 2, Standard Edition, after a materialized view
refresheshes, is there a way I can fire a trigger to write a record to a log
table? I was hunting through documentation and forums, and haven't found
anything.

Martin


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


-----------------------------------------
CONFIDENTIALITY NOTICE

This message and any attachments are from the NAIC and are intended
only for the addressee. Information contained herein is
confidential, and may be privileged or exempt from disclosure
pursuant to applicable federal or state law. This message is not
intended as a waiver of the confidential, privileged or exempted
status of the information transmitted. Unauthorized forwarding,
printing, copying, distribution or use of such information is
strictly prohibited and may be unlawful. If you are not the
addressee, please promptly delete this message and notify the
sender of the delivery error by e-mail or by calling the NAIC Help
Desk at (816)783-8500.


Oracle LazyDBA home page