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?
Userlevel 2
+16
- Contributor
- 2180 replies
-
9 February 2018
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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.