Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have a SDE Geodatabase that contains empty layers created using ArcCatalog. I'd like to import data into those layers from a datapump 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?

share|improve this question
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
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.