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