I need to load some geometries in an Oracle Locator database 11g using the native format sdo_geometry.
1. Am I able to load some shapefiles using ArcCatalog into sdo_geometry (without an SDE schema)?
2. If 1. is not possible, I might have to use an Oracle tool to load some .shp. What would be the Oracle projection to match the Esri SRID 100200 (WGS84 Web Mercator Auxiliary Sphere) so that I can display the data on a Web client using a query layer?
A google on "WGS84 Web Mercator Auxiliary Sphere oracle srid" turned up this. Note that 100200 isn't an SRID, it's a projection code (Esri's definition of "spatial reference" is a lot more than just coordinate system).