Oracle schema is not visible via ArcCatalog

[vsevgu]

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?

[ChrisUnderwood]

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.

[vsevgu]

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;

[MarceloMarques]

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.

[ChrisUnderwood]

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.

[VinceAngelo]

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

[MarceloMarques]

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.

[vsevgu]

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