nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there a safe way to modify geodatabase domains in the database, without using the ArcGIS client like ArcGIS Catalog?

In my scenario Geodatabase is 10.3, Oracle 11g database.

Encontre mais publicações marcadas com

Accepted answers

AsrujitSengupta

Ruling out ArcGIS Client and Python, as George mentioned, there is no safe or supported way of doing this.

All comments

AsrujitSengupta

Modify geodatabase domains as in:

- add new domains?

- delete existing domains?

- Add new coded values?

What about python scripting?

George_Thompson

Hi Tobias,

I would say that there is not a "safe" way to modify the domains in the geodatabase outside of the ArcGIS client (this would include the ways that Asrujit SenGupta mentioned)

Editing the geodatabase outside the ArcGIS client is also unsupported.

Here is some more documentation on the domains:

Domains in a geodatabase stored in Oracle—Help | ArcGIS for Desktop

System tables of a geodatabase stored in Oracle—Help | ArcGIS for Desktop

SQL access to enterprise geodatabase data—Help | ArcGIS for Desktop

Hope this helps.

-George

Managing Data

Modify as in updating existing domains by adding, inserting, removing, and sorting code-description pairs

(Whether export to table-->modify exported copy-->delete existing domain-->create new domain with identical name-->import with the same domain name would arrive at the same result I don't know. But I can't use ArcGIS GP Tools to do this because they don't seem to honor the oracle "become user" syntax I need to use for connecting to the geodatabase.)

Thanks for your help.

AsrujitSengupta

Ruling out ArcGIS Client and Python, as George mentioned, there is no safe or supported way of doing this.

Okay, thanks for the confirmation George Thompson and Asrujit SenGupta.

In case you know of any workarounds, here is my use case: Most GP tools have no problem with oracle become user syntax, but the tools "Table to Domain" and "Sort Coded Value Domain" don't recognize it. For example, if Joe is a power user in the electrical utilities department he connects with username Joe123[electrical]. Works great, except when he needs to run one of these tools against a domain owned by electrical he gets the error "Domain may not be locked as the user is not the owner" unless he actually could connect as electrical . I say could because it isn't a viable option due to IT policy.

ThomasColson

This is for MS SQL, but I can't imagine why it won't work in Oracle:

Re-order Attribute Domain Values

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.