If anyone else could take a look at this: It seems to be depending on the version. We are running into the exact same problem when using 18.104.22.168.0, but when using
22.214.171.124.0 we can import the shape file without a problem. Both versions are the 64-bits version, btw.
When trying a different approach using SQL Loader, we found that apparently there is an ordinate not quite right:
Record 1: Rejected - Error on table "WOZ"."C_IMPORTED_DATA", column "GEOMETRY".SDO_ORDINATES.SDO_ORDINATES.
error converting data
ORA-01722: invalid number
It is strange that one version can deal with this, but the other cannot. Is there anyone from Oracle who can take a look at this? We are now changing our strategy, but would prefer not to have to :-)