Materialized view options

  • From: Dustin Hayden <DHayden@xxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 15 Oct 2014 16:21:00 +0000

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: