FAQ: Can Oracle's export and import utilities be used to transport ArcSDE data?
Can Oracle's export and import utilities be used to transport ArcSDE data?
Yes they can, as long as these two factors are kept in mind:
1. ArcSDE feature classes and rasters exist as a number of tables and related database objects. It's important that all necessary objects are exported along with the data tables. Leaving any related object behind will render the data inoperable in the target database. Therefore, it is recommended that the export include the data owner's entire schema.
2. ArcSDE data objects rely on the metadata repository in the SDE user's schema to manage the data and provide structure to it. Therefore, the entire SDE schema must be included in the export/import operation.