UPDATE building a 

Set a.GRID_ID =  (SELECT f.OBJECTID 
                  FROM  FISHNET_500m f
                  WHERE SDO_Contains( f.shape, a.centroid_geom) = 'TRUE');

SELECT f.OBJECTID 
FROM  FISHNET_500m f, building a
WHERE SDO_Contains(f.shape, a.centroid_geom) = 'TRUE';   

CREATE INDEX centroid_geom_SPX ON "TEST_3D"."BUILDING"("CENTROID_GEOM") INDEXTYPE IS MDSYS.SPATIAL_INDEX

select * from all_sdo_geom_metadata;

UPDATE user_sdo_geom_metadata
set diminfo = SDO_DIM_ARRAY(
SDO_DIM_ELEMENT('X',0,0.1000000,0.005),
SDO_DIM_ELEMENT('Y',0,0.1000000,0.005))
WHERE table_name = 'building'
AND COLUMN_NAME = 'centroid_geom';