This discussion is archived
4 Replies Latest reply: Jul 19, 2012 3:52 AM by David Last RSS

on commit for mview refresh is not generated in DDL

KevinDavis Newbie
Currently Being Moderated
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