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 '13 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 '13 at 14:18
  • try it on a DEV/LAB environment first – Mapperz May 6 '13 at 14:21
  • Importing from the datapump after making sure that layers are registered in both databases worked. Thanks – yo_haha May 6 '13 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 '14 at 22:45

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, privacy policy and cookie policy

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