CODEWITHSUNDEEP
oracle-databasegeometry
Jafar Kofahi
Jafar Kofahi

Reputation: 763

Copy table with sdo_geometry data

Is there a direct way to copy a table with SDO_Geometry data from one schema to another?

I usually convert the SDO_GEOMETRY data into WKT then copy it to the other schema then convert it back to SDO_GEOMETRY. But I might need to do this more often, so I am wondering if there is a better/more direct way to achieve this?

Upvotes: 1

Views: 1716

Answers (1)

Dba
Dba

Reputation: 6639

One of the best possible method to copy spatial data from one schema to another is exp/imp or expdp/impdp geometry tables.

Upvotes: 2

Related Questions