Could you please suggest, how to refresh a materialized view without drop/create? 1) Existing materialized view MV1 which refers to DB1 2) Created a new database link which points to DB2 3) When the dependent MV1 has been refreshed, it still gets data from DB1. 4) Did executed drop and create MV1 then it got refreshed and was updated with DB2 data. Is there any way instead of drop and created, can we use ALTER statement instead of drop and create.
Thanks Please help
I didn't find the right solution from the Internet