I want to make Oracle execute the DBMS_REFRESH package, without having to expose my users to SQL*Plus.
Is there a way I can either package the DBMS_REFRESH command into a stored procedure, or some other packaging, like an executable? Ideally, I'd like to make it so users can just click on a button on a webpage and have the Oracle refresh it's snapshots.
Is there a way I can either package the DBMS_REFRESH command into a stored procedure, or some other packaging, like an executable? Ideally, I'd like to make it so users can just click on a button on a webpage and have the Oracle refresh it's snapshots.