Skip to main content

I have setup the diminfo coordinates, i have created a spatial index and still I am unable to view the oracle table in arcgis. The table is in oracle with geometry and correct diminfo, why can't i see the table in arcgis.

My settings


@Jacq did you create a primary key constraint in your table. I believe Arc needs this to reads. Are you using ArcCatalog?

ALTER TABLE tableName ADD(
CONSTRAINT id_pk PRIMARY KEY (ID));


Do you have a field in your data that can be used as a primary key (unique) and is an integer?


@Jacq did you create a primary key constraint in your table. I believe Arc needs this to reads. Are you using ArcCatalog?

ALTER TABLE tableName ADD(
CONSTRAINT id_pk PRIMARY KEY (ID));

I just did that, using Toad for oracle, still unable to see the table in ArcCatalog

 

 


Do you have a field in your data that can be used as a primary key (unique) and is an integer?

Yes, i used that field as the index field as well

 

 

 

 


Do you have a field in your data that can be used as a primary key (unique) and is an integer?

snapshot of table

 

 


I still need some help, if anyone has any experience with this it would be much appreciated

 

 


Reply