ArcCatalog and sdo_geometry

Question

Hello,

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?

Thanks in advance,
Ganael

Ganael_Jatteau · Answer

Thanks for the links. I understand using ArcMap 10.1 would solve all the problem so that I don't have to care about the Oracle SRID.

Cheers.

jskinner · Answer

Hello,

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)?

Thanks in advance,
Ganael

Yes, at 10.1 you can load shapefiles into a database just as you could for a geodatabase.

http://events.esri.com/uc/QandA/index.cfm?fuseaction=answer&conferenceId=DD02CFE7-1422-2418-7F271831F47A7A31&questionId=3949

VinceAngelo · Answer

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).

- V