Re: stopping archive log without rebooting the database

From: Alex Ivascu <alexdivascu_at_yahoo.com>
Date: Mon, 28 Jan 2002 07:01:35 GMT
Message-ID: <jH658.3674$Ei.3049243@typhoon.we.rr.com>

ALTER TABLESPACE USERS NOLOGGING; I assume that should work.

Alex

Message Alex Ivascu Oracle / SQL DBA nMetric 3070 S. Bristol Street Suite 100 Costa Mesa, CA 92626 direct: 714-424-4406 mobile: 909-264-5144 alex.ivascu_at_nMetric.com
"Mini Nadupparambil" <mchempa_at_home.com> wrote in message news:hP158.5975$p5.1144323_at_news1.rdc1.nj.home.com...
> I am doing a reorg of one big tablespace. This process generates too much
> redo and fills up my archive log directory. Is there a way to stop the
> archive log without shutting down the database during the reorg process?
>
> Thanks,
>
> Mini
>
>
Received on Mon Jan 28 2002 - 01:01:35 CST