Copy two geometries from Oracle to Oracle

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