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; } } }

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?

Encuentra más publicaciones etiquetadas con

Geodatabase

Database Access

Databases

Accepted answers

All comments

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.

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

MMBR

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

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;

MMBR

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.

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

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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