Oracle connector with Oracle materialized view

  • 30 January 2020
  • 2 replies

Hi Team,

Is it posible from TX Oracle connector to export data to a materialized view in Oracle instead of a table ?


Best answer by JTreadwell 31 January 2020, 00:28

View original

2 replies

Userlevel 3
Badge +5

From my understanding, a materialized view displays data that exists in one or more other tables in the same database. 

However the way Discovery Hub data Export works is that it writes data into a new data destination e.g. Oracle. 

So by nature, these two operations are incompatible, there is no way to write data directly to a view itself. 

Thanks for the clarification.