Calling the Oracle Spatial shapefile loader from within the Oracle database itself 
(Simon Greener) Oracle makes available for download from its website a shapefile loader called shp2sdo. Loading data using this tool is a four step process:
--Execute shp2sdo to create a set of sqlplus and sqlldr files.
--Use SQLPlus to run the SQL file generated by shp2sdo to create the table and user_sdo_geom_metadata entries.
--Load the actual data (stored in files generated by shp2sdo) into the created table using sqlldr.
--Finally, run SDO_GEOM.VALIDATE_GEOMETRY to identify incorrect geometries, correct them using SDO_UTIL.RECTIFY_GEOMETRY and other tools, processing and, finally, create spatial indexes etc.
Read Article >>
