Re: Which tablespace offline mode will cause a checkpoint to occur?

On Thu, 19 Jun 2003 06:37:28 GMT, Peter <peter_at_nomorenewsspammin.ca> wrote:

>If you perform
>
>alter tablespace offline
>
>which mode will cause a checkpoint to occur?
>
>Normal, immediate or transactional?
>

Hi Peter,

"Transactional" does not exist (in 9i). "Temporary" does.

Strictly speaking, none of them will cause a checkpoint!

A checkpoint is an instance-wide event, causing ALL dirty blocks in the buffer to be written to ALL their respective datafiles.

 But "normal" will cause all buffer blocks belonging to the datafiles of this particular tablespace to be written to the files. So "Normal" will cause a "checkpoint" for this particular tablespace, which means it can be taken online again without recovery.

• Kenneth Koenraadt