Database Reference
In-Depth Information
be online. No recovery is necessary when bringing the tablespace
ONLINE again using the following statement.
ALTER TABLESPACE users ONLINE;
If you use the TEMPORARY clause instead of NORMAL no
data files are checked whether they are online or not. Oracle
performs a checkpoint whenever you use the ALTER
TABLESPACE with TEMPORARY clause. Media recovery is
necessary when you try to bring the tablespace ONLINE using
the above-mentioned statement. With IMMEDIATE as shown
below, Oracle takes the tablespace offline immediately without
performing even Checkpoint.
ALTER TABLESPACE users OFFLINE IMMEDIATE;
FOR RECOVER clause in the ALTER TABLESPACE
statement, Oracle places the tablespace in recovery mode. Like I
said before, the applications of these commands are discussed in
Backup and Recovery chapter. Remember that the SYSTEM
tablespace can never be placed in OFFLINE mode, as the data
dictionary has to be ONLINE all the time.
Search WWH ::
Custom Search