Dear all,
I am looking for an answer if there is any way we can export and then import a schema user from one Oracle/ArcSDE setup to another. Just to explain myself here, Oracle export utility creates a dump file of what a specific user owns when we use 'exp sys/... fromUser=... toUser=...' syntax and it does not export ArcSDE specific metadata from the ArcSDE system tables which ArcSDE needs to perform specific operations e.g., maintaining version, feature and raster datasets etc.
If we exports a full dump then SDE user and its specific metadata is also exported which on import works fine in the target environment provided we have same arcsde version installed on both environments. My first question is if there is a way we can achieve export and then import of a single schema user so that its SDE user specific metadata and hence ArcSDE functionality is maintained as mentioned above.
My second question which is a bit relevant is that if we know how ArcSDE is maintaining its meta data when a feature or raster dataset is created in ArcCatalog? I tried setting up Oracle Audit tool to get a little insight about names of the tables and type of DML activity but am not sure if it is safe so, I wanted to confirm first.
My working environment is 64bit ArcSDE 9.3.1 with Oracle 11g R2.
