search

PMACS / scenic_oracle_enhanced_adapter

OracleEnhanced adapter for Scenic gem.
MIT License
5 stars 2 forks source link

Correct refresh_materialized_view #22

Open riyengar8 opened 1 year ago

riyengar8 commented 1 year ago

I think the refresh_materialized_view method in this adapter is wrong.

UserCourse.refresh

I think the correct way to refresh a MV in Oracle is something like so:

BEGIN DBMS_SNAPSHOT.REFRESH('MVIEW_NAME'); END;

emolayi commented 1 year ago

Looks like the regular oracle adapter uses the correct code: https://github.com/cdinger/scenic-oracle_adapter/blob/main/lib/scenic/adapters/oracle.rb#L50

Actually, it's different....the internet seems to prever dbms_mview.