Question

Copy two geometries from Oracle to Oracle

  • 4 December 2013
  • 4 replies
  • 3 views
J
Rank
Badge +1
  • jimo Participant
  • Participant
  • 126 replies
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?

 

 

Thanks

4 replies

fmelizard
Rank
Userlevel 4
Badge +13
Hi,

 

 

Have you tried setting the handle multiple spatial columns parameter to yes under the reader and writer parameters> advanced?

 

 

Itay
J
Rank
Badge +1
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
fmelizard
Rank
Userlevel 4
Badge +13
I see, any luck with a dynamic translation?
david_r
Rank
Userlevel 4
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

Reply


Community Stats

28,709
Posts
109,483
Replies
36,556
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.