export and import

Question

Hi experts

I am working with ArcGIS 10.1, Oracle SDE geodatabase.
I exported (by using XML workspace) set of feature classes from a schema (schema only) succesfully from one instance.
I tried to import these to same schema in another instance, then it is failed with a error:
Import XML failed ....ORA 01031 insufficient privileges.

What kind of privileges are required to improt xml workspace document ??

On the other hand, Can I use Oracle utilities for export and import for geodatabase ??

Regards

VinceAngelo · Answer

Is there any to use REMAP_SCHEMA in importing xml workspace document.

XML workspace documents should be RDBMS-agnostic.
When i used oracle utilities to migrate data, the feature classes are to be registered again with geodatabase i think ?

Yes, they would need to be registered (unless they were corrupted by the process --
some geodata cannot be transferred on a piecemeal basis).What is the best way to backup and restore geodatabase?

"Best" is in the eye of the beholder.  There are too many use paradigms and too many 
possible ways to get there to say.  The key part about backups is to validate them, lest
you be like the individual who made a daily backup to floppy disk, and stuck it to the
file cabinet with a strong magnet to make sure it didn't get lost.

- V

jayasudha · Answer

Hi, Thanks to both of you.

It is succesful when i imported to same schema, earlier i tried in another schema.
Is there any to use REMAP_SCHEMA in importing xml workspace document.
When i used oracle utilities to migrate data, the feature classes are to be registered again with geodatabase i think ?
What is the best way to backup and restore geodatabase ?

EmadAl-Mousa · Answer

@Vince i agree esepcially with "st_geoemtry"