B$ tables don't show up in the Oracle table list pickers

Article Number: 000002095 - Last Modified: Dec 5, 2011

The B$ tables used by the G/Technology data model don't show up in the Oracle reader table list pickers

Question

Why can't I see the B$ tables in my Oracle spatial and non-spatial table lists and how can I get access to them?

Answer

The B$ tables don't show up in the lists of tables in the Oracle readers because FME considers them to be Oracle system tables. There are many system tables in Oracle with a $ in the name and we filter these out rather than clutter up the table lists.

There is an existing problem report asking for support of the B$ tables because these are used by Intergraph's G/Technology data model and are valid data tables. Currently the only way to get access to these tables is to manually type the tablename in the tablename text box. Then they can be used just like any other table.