Can someone share how can we create materialized view in oracle using liquibase?
Sample would help. Tried to explore all possible options from liquibase documentation. Normal view is created but facing issue with materialized view
Can someone share how can we create materialized view in oracle using liquibase?
Sample would help. Tried to explore all possible options from liquibase documentation. Normal view is created but facing issue with materialized view
Hi @jaiu ,
I think Liquibase core does not support creating and refreshing (Oracle) materialized views, but you might want to look into this extension: https://liquibase.jira.com/wiki/spaces/CONTRIB/pages/3112975/Oracle+Extensions
Hope this helps,
Eduard
Hi @EduardUta,
is it the same case for postgres? I used GenerateChangeLog to generate xml changelog for existing postgres db. I don’t see the xml or xml(sql) changeset for the materialized view.