Oracle Create spatial index

Note: if geometries are defined using numbers with up to 3 decimal positions (for example, 12.345) the tolerance should be 0.0005.

define SRID=90112
define allLEFT=000000
define allRIGHT=300000
define allBOTTOM=289000
define allTOP=630000
define accX=0.0005
define accY=0.0005
define geotabel=Table1
define geokolom=GeoColumn1
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME=Upper('&geotabel');
DROP INDEX &geotabel._SP_IDX;
INSERT INTO USER_SDO_GEOM_METADATA VALUES
  (Upper('&geotabel'),Upper('&geokolom'), MDSYS.SDO_DIM_ARRAY
    (MDSYS.SDO_DIM_ELEMENT('X', &allLEFT, &allRIGHT, &accX),
      MDSYS.SDO_DIM_ELEMENT('Y', &allBOTTOM, &allTOP, &accY) ), &SRID );
CREATE INDEX &geotabel._SP_IDX ON &geotabel. ( &geokolom ) INDEXTYPE IS MDSYS.SPATIAL_INDEX;