CREATE TABLE "DISTRICT_TEST" (
    "OBJECTID" NUMBER(10) NOT NULL,
    "SDE_ID" NUMBER(10) DEFAULT 0 NOT NULL,
    "ALIVE" NUMBER(1) NOT NULL,
    "FEATURENAME" VARCHAR2(255 char),
    "SDEID" NUMBER(10) DEFAULT 0 NOT NULL,
    "SHAPE" "MDSYS"."SDO_GEOMETRY",
    "VALIDFROM" DATE,
    "VALIDTO" DATE,
    "ACTION_OBJECTID" NUMBER(19),
    CONSTRAINT "SYS_C0059257" PRIMARY KEY("OBJECTID")
    USING INDEX TABLESPACE "GIP_I"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
    TABLESPACE "GIP_D" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0)
    LOGGING
    MONITORING;
    
INSERT INTO
   "MDSYS"."USER_SDO_GEOM_METADATA" (
	 "TABLE_NAME", "COLUMN_NAME","DIMINFO", "SRID"
   ) VALUES (
   'DISTRICT_TEST','SHAPE',
   SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -3000000, 3000000, 0.01), SDO_DIM_ELEMENT('Y', -5000000, 5000000, 0.01)),
   31285
);

CREATE INDEX "GIPTEST"."SPATIDX_DISTRICT_TEST" ON "GIPTEST"."DISTRICT_TEST" ("SHAPE") INDEXTYPE IS MDSYS.SPATIAL_INDEX
   PARAMETERS ('LAYER_GTYPE=COLLECTION SDO_RTR_PCTFREE=10 INITIAL=64K ');

GRANT SELECT ON GIPTEST.DISTRICT_TEST TO R_GIP_RO, R_GIP_RW;
commit;

   
insert into district_test (objectid, alive, featurename, shape) values (42, 1, 'test',
SDO_GEOMETRY(2007, 31285, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARRAY(1670.0625, 341194.008, 1666.21875, 341209.484))
);