topic How to find the object class extension that relates to each feature class/tables at my database in arccatalog? in Data Management Questions

How to find the object class extension that relates to each feature class/tables at my database in arccatalog?

spiderman90 — Sun, 25 Jun 2023 19:21:28 GMT

Hello ,

i would like to check my database at arc catalog , to find which feature class /table relates to object class extension and depends on custom extension .

and to sure if the appropriate class extension are registered on this server

How to achieve it to check which class extension is usable or not necessary ?

Re: How to find the object class extension that relates to each feature class/tables at my database in arccatalog?

MarceloMarques — Mon, 26 Jun 2023 00:18:48 GMT

see the ArcFM article below.

https://myarcfm.schneider-electric.com/myarcfm/s/article/How-To-ArcFM-How-to-Get-Object-Type-GUIDs-in-10-x-Geodatabases

Re: How to find the object class extension that relates to each feature class/tables at my database in arccatalog?

spiderman90 — Mon, 03 Jul 2023 22:01:12 GMT

@MarceloMarques
how could I do that with sql developer ?

i tried to check the tables but I did not get the idea .

could u tell me what should I change to write the same script in sql developer ?

thanks a lot for help

Re: How to find the object class extension that relates to each feature class/tables at my database in arccatalog?

MarceloMarques — Wed, 05 Jul 2023 15:33:52 GMT

@spiderman90 -

This ArcMap Help link will assist to understand more.
https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/overview-geodatabase-system-tables.htm

the same query from the ArcFM Support site will work in Oracle SQL Developer.
https://myarcfm.schneider-electric.com/myarcfm/s/article/How-To-ArcFM-How-to-Get-Object-Type-GUIDs-in-10-x-Geodatabases
open a new Query Window in Oracle SQL Developer, copy + paste the Query and execute to see if it works, if you have further questions then I suggest you to open a support ticket in the ArcFM Support Site Login (site.com)

I had to change the queries a little to work with Oracle and shall work with Oracle Geodatabase SDE Repository version 10.x / 11.x but if you ran into an issue then is best if you open an ArcFM support ticket.

select * from sde.GDB_ITEMTYPES;

SELECT
items.*
FROM sde.GDB_ITEMTYPES itypes
inner join sde.GDB_ITEMS items on itypes.uuid = items.type
WHERE
itypes.name = 'Table'

SELECT
items.*
FROM sde.GDB_ITEMTYPES itypes
inner join sde.GDB_ITEMS items on itypes.uuid = items.type
WHERE
itypes.name = 'Feature Class';

You can log an ArcFM support case or ask an question in the ArcFM forums.

1. Open the Schneider Technical support page.

https://myschneider.force.com/myarcfm/s/login/

2. Create a support account

3. Go to “Log a Case"