-- TABLE T_SIT_COL

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES ('T_SIT_COL', 'SIT_GEOM', MDSYS.SDO_DIM_ARRAY
(MDSYS.SDO_DIM_ELEMENT('LONG', -73.994423393, -28.835883971, 5.0E-8),
MDSYS.SDO_DIM_ELEMENT('LAT', -33.752061377, 5.271806856, 5.0E-8)), 8307);


-- TABLE ECC

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES ('ECC', 'ECC_LOCALIZACAO', MDSYS.SDO_DIM_ARRAY
(MDSYS.SDO_DIM_ELEMENT('LONG', -73.994423393, -28.835883971, 5.0E-8),
MDSYS.SDO_DIM_ELEMENT('LAT', -33.752061377, 5.271806856, 5.0E-8)), 8307);

-- TABLE NCR

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES ('NCR', 'NCR_LOCALIZACAO', MDSYS.SDO_DIM_ARRAY
(MDSYS.SDO_DIM_ELEMENT('LONG', -73.994423393, -28.835883971, 5.0E-8),
MDSYS.SDO_DIM_ELEMENT('LAT', -33.752061377, 5.271806856, 5.0E-8)), 8307);


-- TABLE PONTO

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES ('PONTO', 'PON_GEO', MDSYS.SDO_DIM_ARRAY
(MDSYS.SDO_DIM_ELEMENT('LONG', -73.994423393, -28.835883971, 5.0E-8),
MDSYS.SDO_DIM_ELEMENT('LAT', -33.752061377, 5.271806856, 5.0E-8)), 8307);

-- TABLE PORTO

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES ('PORTO', 'POR_POSICAO', MDSYS.SDO_DIM_ARRAY
(MDSYS.SDO_DIM_ELEMENT('LONG', -73.994423393, -28.835883971, 5.0E-8),
MDSYS.SDO_DIM_ELEMENT('LAT', -33.752061377, 5.271806856, 5.0E-8)), 8307);