Originally posted by akhadar
Hello jurij
in 'ALTER TABLESPACE TABLESPACENAME OFFLINE (NORMAL,TEMPORARY,IMMEDIATE)' command
Under what circumstances the options 'temporary' and 'immediate' are used.Even though in temporary option the checkpoint is performed while taking the tablespace offline still we need to perform media recovery. why?

regards
akhadar
May I, ahem...

If no files are offline, but you use the temporary option, media
recovery is not required to bring the tablespace back online.
However, if one or more files of the tablespace are offline
because of write errors, and you take the tablespace offline
temporarily, the tablespace requires recovery before you can
bring it back online.

HTH