There is no conversion function in the Oracle Database to generate Shape files from SDO_GEOMETRY. However, the PL/SQL package SDO_UTIL provides conversion functions from/to GML, KML, WKT/WKB, GeoJSON, or JSON, hence well-known and often used standards for spatial data.