Category "materialized-views"

Can i replace an existing normal table with a materialized view

I've searched but found no answer, so i resort to you. I have an Oracle table, say "Countries" that exists for ages in database 2 (target). Now, we want to sync

Query against a materialized view with uniqExact column fails due to memory limit

I have a materialized view with the following structure: CREATE MATERIALIZED VIEW events_daily ENGINE = AggregatingMergeTree() ORDER BY ( owner_

Listing tables USED BY materialized view in PostgreSQL?

I've googled for it, both couldn't find an answer. How can I list tables used by materialized view (must not use the information_schema views) in PostgreSQL? Th

ORA-12015: cannot create a fast refresh materialized view from a complex query

I am using below query to build a materialized view. CREATE MATERIALIZED VIEW gcms_business_profile_mview BUILD IMMEDIATE REFRESH FAST WITH PRIM