Procedure
- In the database home page, select the Administration tab
from the tool bar.
- In the Storage area, click Tablespaces.
- Click Create just above the Tablespace
listings table.
- In the Name field under the General tab,
provide a name for the Temporary Tablespace.
- Verify that the sections, Extent Management, Type,
and Status have the following values selected.
- Select Locally Managed for Extent
Management
- Select Temporary for Type (do
not checkSet as default temporary tablespace)
- Select Read Write for Status
- Click Add in the Datafiles section.
- In the Create Tablespace: Add Datafile page,
provide a name for the Datafile in the File Name field
and accept the default location in the File Directory field.
- Specify a size for the tablespace. Temporary Tablespaces
can typically be one-fourth the size of the Permanent Tablespace.
However, this size can change drastically depending on your schemas.
- (Optional) If you want the Temporary Tablespace size to
increase automatically when data exceeds data size requirements, check Automatically
extend datafile when full (AUTOEXTEND) under the section, Storage.
- Click Continue and in the Create
Tablespace page click OK.
Results
In the Tablespace page, the Temporary
Tablespace you just created is listed in the Results table.