We have a prod database, with an SDE schema. We want to install a new SDE instance 9.3.1 and link it to a copy of the prod database.
ArcSDE 9.3.1 on Linux SLES 4
Now, what is the best way to do this. It isn't an upgrade, so you can't really upgrade the SDE install I think? If you simply install the SDE on top of a pre-existing SDE schema, there are all sorts of links broken, indexes, data issues, etc.
So, if I am correct, then is the only way to go, is to build an empty database (save from the users table) and then import all of the data via sdeimport (obviously using the date from a sdeexport)?
I am not normally involved with SDE, preferring to leave it with those mystical creatures, the DBA's, but I can't find one here (I believe they Apparate and Disapparate without control) so have no option but to do this myself, and find myself without the 100% self belief it is the right way to go.
We have no way of accessing the original data live, so have to export the Oracle data from one area to another, before we can access it e.g. we cannot simply access the live data 'live' as such.