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 tables listing
all the Tablespaces.
- In the Name field under the General tab,
provide a name for the Permanent Tablespace.
- Verify that the sections, Extent Management, Type,
and Status have the following values selected.
- Select Locally Managed for Extent Management
- Select Permanent for Type (do
not checkSet as default permanent 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. Typical size requirements are
250MB for your schema repository and 250 MB for every 1000 records in the
user database. However, these sizes can change drastically depending on your
schemas.
- (Optional) If you want the Permanent 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 Permanent Tablespace
you just created is listed in the Results table.