Database copy of a SDO_GEOMETRY column fails in SQL Developer 3.2.20.09

user10768987

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

user10768987

Still have the problem... Seems to be a bug in SQL Developer?

Unknown

Welcome to the forum!

Whenever you post provide your full version number for Sql Developer and, if a database is involved the name and full version of the DB.
>
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?
>
Since you haven't posted your version and provided the exact steps you are using we have no idea what you are doing to try to copy a table.

thatJeffSmith-Oracle

I was able to reproduce this with OE.CUSTOMERS.

Do we support this - yes.

Bug 16761538

Edited by: Jeff Smith SQLDev PM on May 3, 2013 10:38 AM