Skip to Main Content

Database copy of a SDO_GEOMETRY column fails in SQL Developer 3.2.20.09

user10768987Apr 11 2013 — edited May 3 2013
I'm trying to copy a table that has a SDO_GEOMETRY column and it just fails:

Moving Data for object LOCATION
Unable to perform batch insert.
LOCATION ORA-00932: inconsistent datatypes: expected MDSYS.SDO_GEOMETRY got CHAR


What's the workaround for this or SQL Developer doesn't support this?

Edited by: user10768987 on Apr 11, 2013 11:05 AM
Comments
Post Details
Added on Apr 11 2013
3 comments
491 views