AnsweredAssumed Answered

Oracle Schema - register in SDE?

Question asked by _robert_ on Aug 24, 2020
Latest reply on Aug 24, 2020 by asrujit_pb

Hi there,

 

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

Outcomes