Hello @at101

Thank you for your quick reply @trentatsafe.

So, I am currently using GeoDB writer, but am looking to speed up the data load.

Also note that I am loading data into SDE using 5 engines concurrently.

In this case, I am only doing inserts.

In order to speed things up, I tried using legacy SDE writer as well. However, I see this error "Unable to set the version 'SDE.DEFAULT' to the state '471059'. Some or all changes made will be lost. Error while performing SE_version_change_state:SDE_ERROR_CODE(-174) Attempted to change state of version, but state already changed".

So, I was tempted to try oracle spatial to see how the performance would be and if that throws any error. As I am doing disparate inserts I don't see any data corruption issues.

I understand, I will need to make entries into "USER_SDO_GEOM_METADATA" based on this article. But before I go there, it would be great if I can get a confirmation that we can indeed write to oracle geodatabase using FME oracle spatial object even if there is no oracle spatial license installed.

The Oracle database includes Oracle Locator if you do not have the Oracle Spatial license.

That means the geometry types are available (as is the Spatial indexing).

According to the license you can not use Oracle functions to create new objects, but because you use FME you are not using Oracle Spatial specific functionality.

So, all you will need is the FME database edition and an Oracle client. If you can select the Oracle Spatial writer in FME, you should be fine.