Export/Import of spatial data

[Rob van Rijen]

Hi,

Does PL/SQL Developer (7.1.5.1398) support the export and import of tables with a mdsys.sdo_geometry column?

I have tried 3 options so far:

1) Tools -> Export Tables -> SQL inserts. PLS says "Table X contains one or more MDSYS.SDO_GEOMETRY columns. Cannot export in SQL format."

2) Tools -> Export Tables -> PL/SQL Developer. Same message as SQL inserts.

3) Straight from the SQL window -> Export Query results -> SQL inserts. This results in:

insert into X (A, SHAPE.SDO_GTYPE, SHAPE.SDO_SRID, SHAPE.SDO_POINT.X, SHAPE.SDO_POINT.Y, SHAPE.SDO_POINT.Z, SHAPE.SDO_ELEM_INFO, SHAPE.SDO_ORDINATES)
values (1, 2003, 31370, null, null, null, , );

The only option I have not tried is Tools -> Export Tables -> Oracle Export, but in my company the exp and imp executables are not available for developers.

Is there another way to do this? My spatial data contains complex polygons with up to 5000 coordinates.

Thanks!

 

[Marco Kalter]

I'm afraid that the only method is the Oracle format from the Export Tables tool. Having Oracle's imp and exp tools available can be quite useful for developers.

 

[Rob van Rijen]

Thanks Marco... I was afraid of that!

I'll see if I can find a friendly dba and/or service engineer to install these files on my side of the database.