To Create a One Table View
-
Create the view.
CREATE OR REPLACE VIEW MY_VIEW AS SELECT ObjectID, Elevation, Geometry From MY_TABLE;
-
Create a primary key on the view.
ALTER VIEW MY_VIEW ADD PRIMARY KEY (ObjectID) DISABLE;
-
Insert the view in the Oracle Spatial metadata.
INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) VALUES (‘MY_VIEW', 'Geometry', MDSYS.SDO_DIM_ARRAY (MDSYS.SDO_DIM_ELEMENT('X', 714099.913898663, 715312.343907550, 0.000000050), MDSYS.SDO_DIM_ELEMENT('Y', 4908438.586694972, 4910715.465519385, 0.000000050)), 82247);