This is a three-step process using
1) Oracle Map Builder,
2) Oracle SQL Developer, and
3) Bentley Geospatial Administrator.
Download links are included at the end of the note for the Oracle applications.
The SRID value generally corresponds to the EPSG value of the coordinate system. You can verify this in several ways:
1) SRID column of the SDO_COORD_REF_SYS table under MDSYS User,
2) .prj file, or
Other import techniques are possible, including the DGN2SDO tools.
This TechNote is limited to using the Oracle Map Builder import command.
Procedure to load an ESRI Shapefile into an Oracle Database for use with Bentley Map.pdf