Skip to main content
Question

Oracle connector with Oracle materialized view

  • January 30, 2020
  • 2 replies
  • 1 view

Hi Team,

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

2 replies

  • Community Manager
  • January 30, 2020

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. 


  • Author
  • New Participant
  • January 31, 2020

Thanks for the clarification.