On 03/09/2004 02:05:46 PM, Freeman Robert - IL wrote:
> In fact, for the reasons you mention, I didn't want the FK's on... I just
> realized after the fact that they were, and I was looking at the cost and
> was like WOW! Phenominal. However, this is during the initial population of
> the interim table, which I would think would not be impacted by fast or full
> refreshes of the mview. My guess is they copy the data into the table and
> then create the MVIEW afterwards using the prebuilt table clause..... don't
> you think?
Robert, I beg to differ. DBMS_REDEFINITION works online, while the table is
in use. The intermediate table becomes the new table after the procedure ends.
While copying, the original table must be accessible and the rows mustn't
be locked. The only way to actually do that is to store the data from the original
table into an MV.
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Mar 09 2004 - 13:17:08 CST
