REM
REM USER_SDO_GEOM_METADATA, CUSTOMERS and WAREHOUSES
REM


-- inserting data into the user_sdo_geom_metadata view

DELETE FROM USER_SDO_GEOM_METADATA 
  WHERE TABLE_NAME = 'WAREHOUSES' AND COLUMN_NAME = 'WH_GEO_LOCATION' ;

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) 
  VALUES ('WAREHOUSES', 'WH_GEO_LOCATION', 
    MDSYS.SDO_DIM_ARRAY 
      (MDSYS.SDO_DIM_ELEMENT('LONG', -180.0, 180.0, 0.005), 
       MDSYS.SDO_DIM_ELEMENT('LAT', -90.0, 90.0, 0.005)  
      ), 
     8307); 
COMMIT;

DELETE FROM USER_SDO_GEOM_METADATA 
  WHERE TABLE_NAME = 'CUSTOMERS' AND COLUMN_NAME = 'CUST_GEO_LOCATION' ;

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) 
  VALUES ('CUSTOMERS', 'CUST_GEO_LOCATION', 
    MDSYS.SDO_DIM_ARRAY 
      (MDSYS.SDO_DIM_ELEMENT('LONG', -180.0, 180.0, 0.005), 
       MDSYS.SDO_DIM_ELEMENT('LAT', -90.0, 90.0, 0.005)  
      ), 
     8307); 
COMMIT;