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 ?
see the ArcFM article below.
@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
@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-sys...
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-i...
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';