Create materialized view in Oracle using Liquibase

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

1 Like