I have an ArcSDE Geodatabase that contains empty layers created using ArcCatalog.

I would like to import data into those layers from a Data Pump of an Oracle database that has the same structure as the empty database.

How can I perform the spatial data import without getting problems linked to SDE? Is it dangerous to use Oracle data import commands? Should I use some special SDE command to perform the import correclty?

  • 2
    sdeexp/sdeimp is required officially for ArcSDE - there is a 'dark art' for datapumps import export - see forums.oracle.com/forums/thread.jspa?messageID=10253022
    – Mapperz
    May 6, 2013 at 13:46
  • I don't have access to the database of export. I only have a datapump. What I understood from the link you provided: if the tables (from the export and the import databases) are registered as SDE tables, I can perform an "Oracle import operation" from the datapump and everything is going to work fine?!
    – yo_haha
    May 6, 2013 at 14:18
  • try it on a DEV/LAB environment first
    – Mapperz
    May 6, 2013 at 14:21
  • Importing from the datapump after making sure that layers are registered in both databases worked. Thanks
    – yo_haha
    May 6, 2013 at 14:45
  • It looks like you have solved your problem so would you be able to add that, with a few more details, as an Answer, please?
    – PolyGeo
    May 11, 2014 at 22:45

1 Answer 1


The solution I chose is to create a dump of the source database (with the sde user) and load the dump in the target database.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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