Re: How to stop ALL dbms_jobs from executing ?

From: Dave <x_at_x.com>
Date: Tue, 02 Nov 2004 19:53:50 GMT
Message-ID: <iBRhd.7370$Fu2.4475@fe1.news.blueyonder.co.uk>

"G Dahler" <gordon.dahler_at_spamex.com> wrote in message news:feRhd.12761$OD3.744251_at_news20.bellglobal.com...
> Oracle 8174, solaris 2.6
>
> I will be doing some maintenance on a database (moving tables from DMT to
> LMT tablespaces and rebuilding indexes) and I want to minimize access to
> the
> tables during the operation. Is there a way to stop all jobs scheduled
> with
> DBMS_JOB from executing, other than flagging all of them as "broken" ?
>
> I would like NOT to have to shut down the database if possible.
>
> Should I take a cold backup before attempting this or would my hot backup
> suffice if something goes very wrong during the "move" of the tables ?
>
> Thanks
>
>

set job queue process = 0

alter alter database quiesce (i think that stops all transaction) Received on Tue Nov 02 2004 - 13:53:50 CST