When storing spatial data into Oracle, there are a few steps one needs to complete (as shown here too):

insert the data (obviously)
update the USER_SDO_GEOM_METADATA table. This table specifies for each column the bounding box and the SRID (coordinate system).
create a spatial index

I have created a script to this automatically for me, once [...]