RE: Materialized view options

From: Matthew Parker <dimensional.dba_at_comcast.net>
Date: Wed, 15 Oct 2014 09:36:03 -0700
Message-ID: <000c01cfe896$24e639c0$6eb2ad40$_at_comcast.net>

That is the internal information coming from SLOG$ and MLOG$ along with some bitand translations of column info to define a materialized view that can be executed again.

For instance if the dates do not match the original source system materialized view then you can get a "younger than refresh error".

It also contains structural information such as if this is a materialized view on prebuilt table.  

It is not information you need to be concerned with, except in understanding that if you extracted the create materialized view you would not wish to change or remove the information.

We performed a lot of MV moves of database at Amazon using a method that included extracted this information from an export and later generating it directly with PL/SQL. We made some modifications relative to prebuilt table when we moved them before the feature was fully released so we could post drop the snapshot maintaining the table.    

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dustin Hayden
Sent: Wednesday, October 15, 2014 9:21 AM To: oracle-l_at_freelists.org
Subject: Materialized view options  

From a data pump import I can extract the following:  

CREATE MATERIALIZED VIEW "FOCUS"."MV_COO" ("SOID", "COUNTRYINFO") USING ("MV_COO", (8, 'WPCPRDDB.PRDMERDB.SPRICH.COM', 1, 0, 0, "FOCUS", "GENERIC_LOOKUP", '2014-10-05 05:26:22', 0, 0, '2014-10-05 05:26:22', '', 0, 113919599748, 0, NULL), 2097472, 8, ('2010-11-17 13:59:51', 1229, 0, 0, 113919599748, 0, 0, 2, NULL, NULL)) REFRESH COMPLETE AS SELECT     Can anyone tell me what the highlighted portion is telling me?  

Thanks,

Dustin          

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 15 2014 - 18:36:03 CEST