Viewing Tablespaces

A database consists of one or more tablespaces. A tablespace is a logical grouping of physical datafiles. Each tablespace consists of one or more physical datafiles or tempfiles.

You can view a list of the tablespaces in your database on the Tablespaces page. To access the Tablespaces page, you must have a database account that has been granted a DBA role.

Note:

All user data is stored in the USERS tablespace. If you notice that the USERS tablespace is approaching the 4 GB limit, consider dropping unused objects to free up space, or upgrading to Oracle Database Standard Edition or Enterprise Edition.

To access the Tablespaces page:

On the Database Home Page, click the Administration icon and then Storage.
If prompted, enter the appropriate administrator username and password and click Login.

The Storage page appears. See "Monitoring the Space Available".
On the Tasks list, click View Tablespaces.

The Tablespaces page appears and displays the following:
- Tablespace name. Displays the tablespace name.
- Percent Used. Displays a bar chart and percentage that indicates the space used in comparison with the maximum database size permitted.
- Allocated. Displays the amount of space in MB currently allocated to database user objects.
- Used. Displays the amount of space in MB currently used.
- Datafile. Indicates the number of datafiles in the tablespace.
To view additional details, click the tablespace name.

The Datafile page appears and displays the following information:
- Tablespace name
- File Name
- Current size
- Maximum size
- Type of extent management (autoextensible or not)