DROP MATERIALIZED VIEW GTH_VERM2.DGM_HOEHE;
CREATE MATERIALIZED VIEW GTH_VERM2.DGM_HOEHE (FID,HOEHE,RW,HW)
TABLESPACE USER_DATA
PCTUSED    0
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOCACHE
NOLOGGING
NOCOMPRESS
NOPARALLEL
BUILD IMMEDIATE
REFRESH FORCE ON DEMAND
WITH PRIMARY KEY
AS 
/* Formatted on 19/09/2013 16:14:27 (QP5 v5.227.12220.39754) */
SELECT f.fid,
       TO_CHAR (ROUND (f.geom.sdo_point.z, 1)),
       ROUND (f.geom.sdo_point.x, 0),
       ROUND (f.geom.sdo_point.y, 0)
  -- as fid,hoehe,rw,hw

  FROM dgm_50 f;


COMMENT ON MATERIALIZED VIEW GTH_VERM2.DGM_HOEHE IS 'snapshot table for snapshot GTH_VERM2.DGM_HOEHE';

CREATE UNIQUE INDEX GTH_VERM2.DGM_HOEHE_P ON GTH_VERM2.DGM_HOEHE
(FID)
LOGGING
TABLESPACE USER_DATA
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;