SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Locked Post

New comments cannot be posted to this locked post.

Locked on May 31 2013

Added on Apr 11 2013

#developer, #spatial, #sql, #sql-developer

3 comments

651 views