Schemas not showing up for Oracle 11GR2

I am having an issue with schemas from Oracle 11GR2 not showing up. There are a total of 138 schemas in the database of which only 38 shows up.

Is there a bug or limitation?

Hi @banup

Quick Q, when adding the Oracle data source, what was the user (schema) that you had provided. Was it SYS or SYSTEM or an application user


It was Application User with Read access to all the schemas. The user schema is TMARSDBA

Dremio is able to list schemas from A thru D. after D none of the schemas get listed including the user schema


Banu A Parasuraman
Sr Architect, GPSC Supply Ops, Order Fulfillment
Cell: 2483105671

Hi @banup

Is there a chance that the schemas that are showing up only have synonyms in them?