Creating a Permanent Tablespace

Procedure

  1. In the database home page, select the Administration tab from the tool bar.
  2. In the Storage area, click Tablespaces.
  3. Click Create just above the tables listing all the Tablespaces.
  4. In the Name field under the General tab, provide a name for the Permanent Tablespace.
  5. 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
  6. Click Add in the Datafiles section.
  7. 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.
  8. 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.
  9. (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.
  10. 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.