title: Oracle Create Materialized View Syntax
body: <p>I've got a materialized view that I've been asked to look at that will not compile. This is part of a database inherited from another company via acquisition. I suspect this is referencing another database that we didn't receive but I can't understand or find the syntax for the USING () portion of this. I've changed some of the names around, but the syntax should be the same. Could someone explain to me what the heck this thing is doing? We've got some Crystal reports that are trying to hit the same table, but can't find it since it doesn't exist in the database being used...</p>
  
  <blockquote>
    <p>CREATE MATERIALIZED VIEW "SCHEMA"."MV_NAME" ("COLUMN1") 
    USING ("MV_NAME", (10, 'DNS_NAME', 1, 0, 0, "ANOTHER_SCHEMA", "TIME_DIMENSION", '2015-04-08 09:32:17', 0, 30278, '2015-04-08 09:32:17', '', 0, 8420605171713, 0, NULL)
    , 2097472, 8, ('2014-12-17 08:14:17', 543, 0, 0, 8421320914252, 268435456, 0, 0, 2, NULL, NULL)) 
    REFRESH FORCE AS SELECT</p>
  </blockquote>