Skip to main content
Answer

Oracle connector with Oracle materialized view

  • January 30, 2020
  • 2 replies
  • 43 views

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

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. 

2 replies

JTreadwell
Employee
Forum|alt.badge.img+5
  • Employee
  • Answer
  • 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
  • Starter
  • January 31, 2020

Thanks for the clarification.