Thanks
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?
Page 1 / 1
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
I see, any luck with a dynamic translation?
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