Thanks
Question
Copy two geometries from Oracle to Oracle
I have an Oracle table with two geometry fields, POLYGON_GEOMETRY and CENTROID_GEOMETRY. I want to copy the table to a new Oracle Spatial database but I have to specify one or the other geometry column names in the reader. How can I copy both geometry fields to the new table?
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.
+21- Safer
Hi,
Have you tried setting the handle multiple spatial columns parameter to yes under the reader and writer parameters> advanced?
Itay
I set both reader and writer parameters for "handle multiple spatial columns" to Yes, but you cannot specify the geometry column names in this case in the reader, and you have to choose one name in the writer. The writer took the polygon geometry, which has an SDO_GTYPE number of 3003 (3D polygon) and wrote it as 2004 (2D heterogeneous). I would like to preserve both geometry names and their geometry types.
Thanks
Hi,
If you're moving data from one Oracle Spatial instance to another, it might be worthwhile to consider the exp and imp tools from Oracle. They are also very fast.
Here is a blog post explaining how to use the exp and imp tools.
David