Schemas not showing up for Oracle 11GR2

1

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?

2

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

Thanks.
@balaji.ramaswamy

3

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

Regards

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

4

Hi @banup

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

Thanks
@balaji.ramaswamy