4 Replies Latest reply: Jul 19, 2012 5:52 AM by David Last-Oracle RSS

    on commit for mview refresh is not generated in DDL

    KevinDavis
      New design > relational > new table w/ single numeric column
      New Oracle 11g physical > new materialized view > on prebuilt table from above > Refresh Clause tab > select ON COMMIT action
      -- add a body for grins

      resulting XML in saved design:
      <?xml version = '1.0' encoding = 'UTF-8'?>
      <SnapshotOraclev11g class="oracle.dbtools.crest.model.design.storage.oracle.v11g.SnapshotOraclev11g" name="TABLE_1" id="E092B588-B0A8-437A-4187-9999090405D9" directorySegmentName="seg_0">
      <createdBy>kdavis1</createdBy>
      <createdTime>2012-07-18 15:28:57 UTC</createdTime>
      <ownerDesignName>OTN_Issue_20120717a</ownerDesignName>
      <action>ON COMMIT</action>
      <defaultSegment>NO</defaultSegment>
      <onPrebuiltTable>8332B16F-E06B-86AC-E123-DDA4F5DFF794</onPrebuiltTable>
      </SnapshotOraclev11g>

      Resulting DDL lacks ON COMMIT:
      -- Generated by Oracle SQL Developer Data Modeler 3.1.1.703
      -- at: 2012-07-18 11:47:26 EDT
      -- site: Oracle Database 11g
      -- type: Oracle Database 11g



      CREATE TABLE "TABLE_1"
      (
      "Column_1" NUMBER
      )
      LOGGING
      ;




      CREATE MATERIALIZED VIEW "TABLE_1"
      ON PREBUILT TABLE
      AS select sum(foo) from bar
      ;




      -- Oracle SQL Developer Data Modeler Summary Report:
      --
      -- CREATE TABLE 1
      -- CREATE INDEX 0
      -- ALTER TABLE 0
      -- CREATE VIEW 0
      -- CREATE PACKAGE 0
      -- CREATE PACKAGE BODY 0
      -- CREATE PROCEDURE 0
      -- CREATE FUNCTION 0
      -- CREATE TRIGGER 0
      -- ALTER TRIGGER 0
      -- CREATE STRUCTURED TYPE 0
      -- CREATE COLLECTION TYPE 0
      -- CREATE CLUSTER 0
      -- CREATE CONTEXT 0
      -- CREATE DATABASE 0
      -- CREATE DIMENSION 0
      -- CREATE DIRECTORY 0
      -- CREATE DISK GROUP 0
      -- CREATE ROLE 0
      -- CREATE ROLLBACK SEGMENT 0
      -- CREATE SEQUENCE 0
      -- CREATE MATERIALIZED VIEW 1
      -- CREATE SYNONYM 0
      -- CREATE TABLESPACE 0
      -- CREATE USER 0
      --
      -- DROP TABLESPACE 0
      -- DROP DATABASE 0
      --
      -- ERRORS 0
      -- WARNINGS 0


      Posts reviewed: (materialized && view) || mview || mv