Other methods for moving a geodatabase in Oracle

You can use Oracle's export and import utilities to transport ArcSDE data. You can also use Oracle's transportable tablespaces. Be sure all necessary objects are exported along with the data tables.

Remember, ArcSDE feature classes and rasters exist as a number of tables and related database objects. Leaving any related object behind renders the data inoperable in the target database. Therefore, it is recommended that the export include the data owner's entire schema plus the SDE user's schema.

The entire SDE user's schema is needed because ArcSDE data objects rely on the metadata repository in the ArcSDE administrator's schema to manage the data and provide structure to it. The SDE user's schema also contains the ST_Geometry type and functions.

Using Oracle transportable tablespaces is especially efficient when moving large databases. You can use the recovery manager (RMAN) utility to move the tablespaces.

Things to consider when transporting tablespaces are as follows:

See the Oracle documentation for the release you are using for information on using import/export, RMAN, and transportable tablespaces.


11/18/2013