Re: Materialized View - Transactional Refreshing

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Thu, 09 Sep 2004 19:41:15 +0200
Message-ID: <8b51k0p37eqddbta8bp77sstjb1unie0sm@4ax.com>

On Thu, 09 Sep 2004 10:50:30 -0400, Peter Sylvester <peters_no_spam_please_at_mitre.org> wrote:

>Is there a way to get Oracle to make this transactional (using a delete
>statement), so the mview will always be usable?

no. Nor does your suggestion make sense because the mview would be locked during the delete, and delete compared to truncate is pretty inefficient.
But if you think a home-grown 'solution' will address your needs, why don't you go ahead knowing better?

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Sep 09 2004 - 12:41:15 CDT