Re: Help

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Mon, 24 Feb 2003 00:02:28 +1000
Message-ID: <kk36a.54192$jM5.135841@newsfeeds.bigpond.com>

"zeb" <thierry.constant1_at_free.fr> wrote in message news:3e58a8bb$0$260$626a54ce_at_news.free.fr...
>
> "CSP" <cspp2201_at_netscape.net> a écrit dans le message de news:
> 3E571704.9020803_at_netscape.net...
> > Hari,
> >
> > Do the following:
> >
> > 1. Alter tablespace <tablespace_name> OFFLINE; #-- I am assuming you
> > database is in Archive log mode.
>
> Is the archive log necessary ????

Hi Zeb,

No it's not.

You can take a datafile offline for this exact purpose. However, Oracle will insist that a checkpoint be successfully completed on the tablespace but as the default is NORMAL (which insists on all datafiles within the tablespace be checkpointed) everything is hunky dory.

Cheers

Richard Received on Sun Feb 23 2003 - 08:02:28 CST