we have an Oracle DB, an SDE schema and multiple data schemas.
It looks like the correct procedure is:
- create a new schema in Oracle
- apply "Create Geodatabase" tool in ArcMap using the newly created schema
It seems I missed the "create geodatabase" bit. We have already entered some data. But I have now noticed that the schema is not part of SDE (table sde.instances does not contain any reference to the schema).
Can I still "register" the schema in SDE?
I noticed a tool called "activate geodatabase" - but it doesnt seem to offer the option "SDE schema" as the tool "create geodatabase" has.
Many thanks, Rob