Question

No tables show up in the FME table list picker. Why?

Answer

There can be a number of reasons why the tables or views don't show up in the table list picker of the Oracle reader

- do you have permission to access the tables? FME requires SELECT access to add a table or view to the table list.

- have you selected the correct Oracle reader?

- Oracle Spatial Object for reading spatial tables
- Oracle Non-Spatial for reading non-spatial tables - or for reading only attributes from spatial tables
- Oracle Spatial Relational for reading spatial tables in the older Oracle Spatial Relational data model
- Oracle Spatial GeoRaster to read Raster data stored in Oracle's Georaster format
- Oracle PointCloud for reading Point Cloud data.

- do your spatial tables have entries in the metadata tables (MDSYS.USER_SDO_GEOM_METADATA)? When looking for tables to add to the table list picker with the Oracle Spatial Object reader we access the MDSYS.SDO_GEOM_METADATA table to extract information such as the spatial extents and the SRID. If your spatial table or view doesn't have an entry in the MDSYS.SDO_GEOM_METADATA table then it won't be included in the table list picker. For more information on adding entries to the MDSYS.SDO_GEOM_METADATA table see Adding metadata entries for Oracle spatial tables and views.

- by default we set a filter in the table list picker of the provided user name.