How to Replicate SYS Views from Oracle

[lyka]

Although user has select permissions, we are not able to view sys views in Oracle such as sys.dba_all_tables, sys.all_views, sys.all_tables

Environment

• Qlik Replicate 

Resolution

Create a new user view that points to the sys view and then consume that with Replicate.

Cause 

Replicate skip the below schemas when selecting the tables:

'SYS','MDSYS','OLAPSYS','WKSYS','CTXSYS','XDB','WMSYS','EXFSYS','ORDSYS','DMSYS'

We explicitly exclude system tables and only utilize user tables.