Re: How to stop ALL dbms_jobs from executing ?

From: G Dahler <gordon.dahler_at_spamex.com>
Date: Tue, 2 Nov 2004 16:22:00 -0500
Message-ID: <WTShd.10891$dj2.591292@news20.bellglobal.com>

"Howard J. Rogers" <hjr_at_dizwell.com> a écrit dans le message de news:4187ed3c$0$15913$afc38c87_at_news.optusnet.com.au...

SNIP
>
> The actual answer to the original poster is that he has to do precisely
> NOTHING to "minimise access to the tables during the [move]". Because
moving
> a table takes an exclusive table lock, and hence the table is protected
> against all DML without further effort on his part.
>

OK. It's just that some of these tables are BIG and I taught that if any massive DML is trying to occur while (or juste before) I start moving these, I may end up with some problems but It looks like there is no problem.

Thanks Received on Tue Nov 02 2004 - 15:22:00 CST