You need not perform media recovery on this tablespace before
placing it back online. You must use this option if the database is in
NOARCHIVELOG mode.
8-10 Oracle Enterprise Manager Administrator’s Guide
Datafiles Folder
Temporary: Takes the tablespace offline in temporary mode.
A checkpoint is performed for all online datafiles in the tablespace but does not
ensure that all files can be written. Any offline files may require media recovery
before you place the tablespace back online.
Immediate: Takes the tablespace offline in immediate mode.
Oracle does not ensure that the datafiles are available, and no checkpoint is
performed. You must perform media recovery on the tablespace before placing it
back online.
Making a Tablespace Read-Only
To change a writeable tablespace to read-only status:
1.
Select the tablespace from the tree list.
2.
Choose Make Read-Only from the Tablespace menu.
You can also change the tablespace status from the Quick Edit Tablespace property
sheet.
Making a Tablespace Writeable
To change a read-only tablespace to writeable status:
1.
Select the tablespace from the tree list
2.
Choose Make Writeable from the Tablespace menu.
You can also change the tablespace status from the Quick Edit Tablespace property
sheet that appears when you select a tablespace from the tree list.
Datafiles Folder
The Datafiles folder contains information about the datafiles in the database. The
listing of the datafiles is arranged in a tree structure that can be expanded to show
individual datafiles along with their respective path information.
For information about datafiles, see the Oracle Server Concepts and the Oracle Server Administrator’s Guide.
Datafiles Multi-Column List
The columns of the Datafile multi-column list are described below:
Managing Database Storage
8-11
Datafiles Folder
Name
Name of the datafile and the path (truncated by ellipses if the path is too long).
Tablespace
Tablespace to which the datafile belongs.
Status
Status of the datafile: Online or Offline.
Size (M)
Size of the datafile in megabytes.
Used (M)
Amount (in megabytes) of data filling the datafile. Displayed as a bar chart.
Creating a Datafile
To create a new datafile, choose Create from the Datafile menu. The Create Datafile
property sheet appears.
The Create Datafile property sheet contains the following pages:
■
General (Basic UI mode)
■
Auto Extend (Advanced UI mode)
Note: The Auto Extend page only appears if the database is version 7.2 or later.
Datafile Property Sheet: General Page
The General page of the Datafile property sheet allows you to modify existing
datafile parameters or create a new datafile when the Create menu option is
selected from the Datafile menu.The General page of the Create Datafile property
sheet is described below:
Name
Name of the datafile to be created.
Enter the file and path name of the new datafile. The filename must be specified
according to the conventions of your operating system.
When altering an existing datafile, you can rename the datafile by typing in a new
name.
Attention: You must rename a datafile if you have changed the name of the
corresponding operating system file or if you have moved the file to a new
location. To rename a datafile, its tablespace must be offline.
8-12 Oracle Enterprise Manager Administrator’s Guide
Datafiles Folder
Attention: When you rename a datafile using the Storage application, the name of
the operating system file is not changed. The new filename is only associated with
the tablespace. Before renaming the datafile using the Storage application, you
must change the name of the file through your operating system.
Tablespace
Name of the tablespace to which the new datafile belongs. Use the drop-down list
to choose the tablespace. You can only choose the tablespace when the datafile is
created.
Status
Online: Specifies that the datafile be placed online.
Offline: Specifies that the datafile be place offline.