RE: Materialized view options

  • From: "Matthew Parker" <dimensional.dba@xxxxxxxxxxx>
  • To: <DHayden@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 15 Oct 2014 09:36:03 -0700

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Dustin Hayden
Sent: Wednesday, October 15, 2014 9:21 AM
To: oracle-l@xxxxxxxxxxxxx
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

 

 

 

 

 

Other related posts: