I have a geographic layer stored in an Oracle Geodatabase with ST_GEOMETRY type.

I'd like to export that layer and its data into a SQL INSERT format in order to import it into another Oracle database which is in another server machine.

After the export I get lines like this:

Insert into myTable(OBJECTID,NAME,SHAPE) values ('2989','MyName','SDE.ST_GEOMETRY(8,1120,672587.528700002,6824864.9106,676521.2799,6829005.2801,NULL,NULL,NULL,NULL,8002536.39765853,16898.2791219904,3,'oracle.sql.BLOB@5e105008'));

I don't know how to deal with the BLOB type. I suppose oracle.sql.BLOB@5e105008references a memory address where some data is stored. How can I export that belob and import it in the new Oracle DB?


Data Pump Export

is a utility for unloading data and metadata into a set of operating system files called a dump file set. The dump file set can be imported only by the Data Pump Import utility. The dump file set can be imported on the same system or it can be moved to another system and loaded there.


  • Should I prefer sdeexport/sdeimport to datapump? – yo_haha Oct 22 '13 at 14:10
  • 1
    sdeexport is slower. – Mapperz Oct 22 '13 at 14:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.