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 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?

share|improve this question
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 at 22:45

1 Answer 1

up vote 0 down vote accepted

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.

share|improve this answer

Your Answer

 
discard

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

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