Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to stop ALL dbms_jobs from executing ?
"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
![]() |
![]() |