Re: take tablespace offline

offline normal checkpoints the files before they go offline.

The details are vague right now, but the other switches do various amounts of checkpointing. From memory, offline immediate doesn't checkpoint anything, and offline temporary checkpoints what it can, and won't throw a blue fit if a file is missing or unavailable.

Unless you are offlining the tablespace to perform recovery, I suggest you stick with normal (which is the default, so you don't actually have to specify the word 'normal').

Use 'temporary' or 'immediate' only when you know there is a problem with the tablespace that you are about to fix up.

Regards
HJR "junfan" <fanjun_at_writeme.com> wrote in message news:97hk1a$sog$1_at_ctss92.sgp.hp.com...
> Hi all,
> I am trying to understand Oracle in detail.I will be appreciated if
 someone
> can tell the difference btw normal and temporary mode and under what
> scenarios I should use normal or temporary mode when taking a tablespace
> offline.
>
> Thansk in advance
>
>
Received on Thu Mar 01 2001 - 07:11:15 CST