Hello!
I have ESRI feature classes stored in oracle Geodatabase. It uses ST_Geometry. I do not have oracle spatial installed on oracle database. Can I still use FME oracle spatial object writer to write to such ESRI Feature class?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+6- Safer
- 278 replies
Hello @at101
If you have a feature class stored in an ArcSDE database(in your case it sounds like an ArcSDE database stored in Oracle). You can use the ArcSDE Geodb Reader/Writer
https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/GEODATABASE_SDE_reader.htm
https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/GEODATABASE_SDE_writer.htm
In order to access these tables in FME/ArcGIS I believe you will need the Oracle Instant Client in order to access. This can be downloaded from the Oracle website. Some articles that may help include:
https://knowledge.safe.com/content/kbentry/19440/comparison-of-fme-readers-and-writers-for-sde-and.html
https://knowledge.safe.com/articles/772/fme-and-esri-arcgis-troubleshooting-guide.html
I hope that helps.
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.
+22- Contributor
- 2179 replies
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.
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.