3 Replies Latest reply: May 3, 2013 9:38 AM by Jeff Smith Sqldev Pm-Oracle RSS

    Database copy of a SDO_GEOMETRY column fails 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