Question
3D geometry to Oracle
Hello all. I am reading a CAD file with 2d geometry, however in a certain moment I force it to 3d geometry with 0 as z value, after that, I am trying to write to Oracle Spatial Object, but what returns is - The geometry type `3002' is not understood by the Oracle Spatial writer . Would you know what is happens? There is a relation with the version 11g? Thanks in Advance.
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.
+22- Contributor
3D support for this type of feature was introduced in Oracle 11.1. Is this the version of Oracle that you are attempting to load? http://docs.oracle.com/cd/B28359_01/appdev.111/b28400/sdo_intro.htm
+2Max - Are you trying to load 3D Solids or 3D Geometry? In Oracle 11.1 solid support was added as David says, but 3D Geometry was supported in versions before that.
SDO_GTYPE 3002 is a 3D Line, 3008 is a Solid
- How are you converting to 3D - with 3DForcer?
- Which version of FME and which version of Oracle?
- What is the setting for dimension in the writer Format Parameters?
- What is the value from Oracle USER_SDO_GEOM_METADATA for this table?