Skip to main content
Question

Oracle connector with Oracle materialized view

  • Jan 30, 2020 2:11 PM UTC
  • 2 replies
  • 2 views

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
  • Jan 30, 2020 11:28 PM UTC

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
  • Jan 31, 2020 7:19 AM UTC

Thanks for the clarification.