Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Materialized Views: Refreshing same MV by 2 calls to DBMS_MVIEW.REFRESH at the same time.

Re: Materialized Views: Refreshing same MV by 2 calls to DBMS_MVIEW.REFRESH at the same time.

From: AEH <gothic_katana_at_yahoo.com>
Date: 19 May 2005 08:37:43 -0700
Message-ID: <1116517063.501770.126990@g43g2000cwa.googlegroups.com>


Hmm. InterMedia Text (Oracle Text in later versions) looks very cool, but is outside of the scope of what I'm doing now.

I think that the On Commit option might work. We are already taking the performance hit for inserting into the staging table in the current setup. There should be no locking issues.

Thanks for your time and help!
A.E. Harris Received on Thu May 19 2005 - 10:37:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US