I am trying to import data from GTECH data base into a File Geodatabe. when I used the Oracle Spatial Relational Reader , I get only two tables our of hundreds of tables. so I switched to using the Oracle Spatial Object. when I use it I get more tables showing and I am able to import them. however, there are many tables do not show on the table list in the reader though. what would be the reason behind that?
Question
GTech Readers
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.
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.
+26- Contributor
The table list, shown in the Oracle Spatial reader, is based on the USER_SDO_GEOM_METADATA.
In general only the tables with a spatial index defined will show up.
Two solutions:
1) Create spatial indexes for the tables or just add the entry in the USER_SDO_GEOM_METADATA
2) Enter the table name in the reader table list manually. FME will find the table, even without metadata.