| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Snapshots: Synchronous refresh?
dpurrington_at_my-deja.com wrote:
>
> Is it possible to refresh a snapshot synchronously? In other words,
> can I refresh a snapshot without having it scheduled as a job?
>
> I'm going to need to prevent users from using the system while the
> snapshots are being refreshed (my snapshots require complete refreshes -
> - Sybase blows). Preventing them from logging in isn't the problem.
> The problem is being able to tell when a snapshot refresh has been
> completed.
>
> To this end, I want to be able to call a stored procedure to perform
> the refresh (like DBMS_REFRESH.REFRESH()), but will my session wait for
> the refresh to be performed, or will this function merely schedule it
> to be performed immediately? If it waits for the refresh to be
> performed, I'll know the refresh is done when I get control back in my
> session. If it doesn't, I'll have to figure out some other way.
>
> Thanks for the help,
> Dave
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
dbms_snapshot.refresh
will do a synchronous refresh
--
"Some days you're the pigeon, and some days you're the statue." Received on Fri Dec 10 1999 - 04:59:04 CST
 |
 |