Re: Does "alter tablespace offline normal" result in a checkpoint

Yes it does. Before the tablespace can go offline, the system must flush dirty blocks from the buffer cache to the tablespace. So a checkpoint is performed.

HTH,
Brian

Peter wrote:
>
> Does
> "alter tablespace offline normal"
>
> result in a checkpoint? The manual is not very clear on this.
>
> On the other hand,
> "alter tablespace offline temporary" will perform a checkpoint
> "alter tablespace offline immediate" will not perform a checkpoint
>
> Thanks

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"