Forum Stats

  • 3,838,759 Users
  • 2,262,398 Discussions
  • 7,900,750 Comments

Discussions

Database copy of a SDO_GEOMETRY column fails in SQL Developer 3.2.20.09

user10768987
user10768987 Member Posts: 4
edited May 3, 2013 10:38AM in SQL Developer
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

Answers

  • Still have the problem... Seems to be a bug in SQL Developer?
  • 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
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 8,700 Employee
    edited May 3, 2013 10:38AM
    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
This discussion has been closed.