Tag Info

New answers tagged


Can we do this inside a Proc - DBMS_OUTPUT.PUT_LINE('Refreshing Materialized views'); -- drop index here BEGIN DBMS_SNAPSHOT.REFRESH('SOME VIEW'); END; -- create index here DBMS_OUTPUT.PUT_LINE('Views refreshed');


Having the origin_remote column in the repositories table allows for an intrinsic consistency, even without check, and you'll keep this consistency when changing DBMS and, more importantly, in the application code. This also allows for a single query when you want to change the origin of a repository, while having your is_origin boolean would imply two ...

Top 50 recent answers are included