Skip to main content
Question

Problem Reading FME created oracle spatial tables in ArcGIS


Forum|alt.badge.img

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.

7 replies

Forum|alt.badge.img
  • Author
  • June 4, 2018

My settings


austinh
Contributor
Forum|alt.badge.img+4
  • Contributor
  • June 4, 2018

@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));


austinh
Contributor
Forum|alt.badge.img+4
  • Contributor
  • June 4, 2018

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


Forum|alt.badge.img
  • Author
  • June 4, 2018
austinh wrote:

@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

 

 


Forum|alt.badge.img
  • Author
  • June 4, 2018
austinh wrote:

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

 

 

 

 


Forum|alt.badge.img
  • Author
  • June 4, 2018
austinh wrote:

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

snapshot of table

 

 


Forum|alt.badge.img
  • Author
  • June 4, 2018
I still need some help, if anyone has any experience with this it would be much appreciated

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings