Skip to main content
Question

Problem Reading FME created oracle spatial tables in ArcGIS

  • June 4, 2018
  • 7 replies
  • 53 views

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

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

@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

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

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