Hi Team,
Is it posible from TX Oracle connector to export data to a materialized view in Oracle instead of a table ?
Solved
Oracle connector with Oracle materialized view
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.
+5From 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.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
