topic Oracle schema is not visible via ArcCatalog in Data Management Questions

Oracle schema is not visible via ArcCatalog

vsevgu — Fri, 23 Jun 2023 08:33:54 GMT

We have oracle(11.2) based Sde (ArcGis Server 10.3).
User U1 creates table T1 using oracle ddl.
This table is available to user U1 from Oracle pl/sql developer and others, except Arc Catalog.
If the user U1 connects to oracle using ArcCatalog, then the schema U1 and the table T1 is unvisible.
What could be the problem?
Should I additionally register in Sde the scheme U1 and table T1?

Re: Oracle schema is not visible via ArcCatalog

ChrisUnderwood — Fri, 23 Jun 2023 08:50:30 GMT

Hello @vsevgu, please can you post an example of your DDL here.

Note, the 10.3 Geodatabase schema is very old and no longer supported.

Re: Oracle schema is not visible via ArcCatalog

VinceAngelo — Tue, 27 Jun 2023 04:08:44 GMT

Both ArcGIS 10.3 and Oracle 11gR2 are ancient. You haven't provided the DDL for table creation, but it seems likely that you have an unsupported datatype (which makes specifying the DDL all the more important).

- V

Re: Oracle schema is not visible via ArcCatalog

MarceloMarques — Sat, 24 Jun 2023 23:10:05 GMT

You shall create new tables using ArcCatalog and not create tables directly using Oracle SQL Developer nor SQL Plus.

Tables created with ArcCatalog are registered with the Oracle ArcSDE Geodatabase.

select * from sde.table_registry order by owner, table_name;

Tables created with Oracle SQL Developer / SQL Plus are NOT registered with the Oracle ArcSDE Geodatabase, therefore ArcCatalog will not display those tables.

There are ways to register a standalone table with the Oracle ArcSDE Geodatabase, for this please look the Geodatabase documentation.

I hope this clarifies your question.

Re: Oracle schema is not visible via ArcCatalog

vsevgu — Mon, 26 Jun 2023 06:53:18 GMT

Thanks for the answer.

The table created with the ddl for example. The table not visible in ArcCatalog

CREATE TABLE U1.TEST1 ( ID NUMBER(10,0) PRIMARY KEY, ISACTUAL NUMBER(1,0), NOTE VARCHAR2(255), SHAPE MDSYS.SDO_GEOMETRY ); insert into mdsys.SDO_GEOM_METADATA_TABLE select 'U1' , 'TEST1' ,'SHAPE' , SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -180, 180, .0005) , SDO_DIM_ELEMENT('Y', -90, 90, .0005)) , 4326 from dual; commit; CREATE INDEX U1.GEOINDSHAPE1 ON U1.TEST1 (SHAPE) INDEXTYPE IS MDSYS.SPATIAL_INDEX NOPARALLEL;

Re: Oracle schema is not visible via ArcCatalog

MarceloMarques — Mon, 26 Jun 2023 15:41:44 GMT

Register a table or view with the geodatabase—ArcMap | Documentation (arcgis.com)
Oracle ArcSDE Geodatabase 10.3 is deprecated and I recommend you upgrade your geodatabase repository to 10.8 and also to use ArcMap/ArcCatalog 10.8 if you attempt to register the table with the geodatabase. If you continue to encounter an issue then is best if you open a ticket with Esri Technical Support to troubleshoot this further.

Re: Oracle schema is not visible via ArcCatalog

ChrisUnderwood — Tue, 27 Jun 2023 13:32:22 GMT

Hello @vsevgu

In my Oracle 19c/Geodatabase 10.8 I created your "U1" user using 10.8 ArcCatalog's Create Database User tool. I then ran your DDL using SQLPlus and your data was then listed in ArcCatalog as you wanted. So in order to do this please update your system to the current versions.

Note, although your data is listed it is not Registered with the Geodatabase.

Re: Oracle schema is not visible via ArcCatalog

vsevgu — Mon, 11 Dec 2023 15:35:29 GMT

Sorry, I forgot to write what the problem was.

For version ArcSDE 9.3, I tried to register layers using version ArcGIS Desktop 10.3. but the maximum version of ArcGIS Desktop for registering layers in ArcSDE 9.3 is 10.2