Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to stop ALL dbms_jobs from executing ?

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US