I've correctly installed Oracle 11g Express Edition database on my machine. After successfully connecting to my database, why can't I use FME's Oracle writers? I get an error message that says my data type is not supported by my Oracle version, and that I should use Oracle 11g.
Why won't FME write to my Oracle 11g Express Edition database?
Best answer by steveatsafe
We recently used Oracle Express 11g on some training machines and we did write geometry but it was simple points, lines, & polygons.
So you can still use the Oracle Spatial writer against an Oracle Express but be aware of the limitations of Oracle Locator feature vs Oracle Spatial option.
The Oracle Locator feature comes in all flavours of server installed Oracle Databases (Express, Standard, & Enterprise) where as Oracle Spatial is an option for Enterprise Edition. Oracle Locator wouldn't suffice as a GIS as you'd be missing much of the typical functions that a GIS would have.
Stepping up to the Oracle Enterprise Edition with the Spatial Option you will be licensed to make full use of Oracle Spatial complex geometries, point clouds and georasters and all the rich GIS like functionality that is part of Oracle Spatial option.
@erik_jan for sure - this is a good way to see if your locator is configured... The locator feature is standard in Oracle 11g+ (Express, Standard, & Enterprise) so it should be there and working out of the box.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.