Viewing Tablespaces

Previous

Next

---

You can use the Oracle Database XE graphical user interface to view a list of tablespaces in the database, view tablespace properties, and view datafile properties.

To view Oracle Database XE tablespaces:

1. Access the Database Home Page.

   See "Accessing the Database Home Page" for instructions.

2. Click the Administration icon, and then click the Storage icon.

3. If prompted for administrator credentials, enter the SYSTEM user name and password or another administrator user name and password, and then click Login.

   The Storage page appears.

4. Under Tasks, click View Tablespaces.

   The Tablespaces page appears, showing space usage for each tablespace and total space usage.

   
   Description of the illustration xe_tablespaces.gif
   
   

   Note the Allocated column does not indicate the maximum size for a tablespace. Rather, it indicates the amount of storage currently allocated to the tablespace. Depending on datafile settings, a tablespace can grow beyond its currently allocated size. For example, the USERS tablespace has one datafile (users.dbf) with an initially allocated size of 100 megabytes (MB). The datafile can autoextend as needed, 10 MB at a time.

5. (Optional) Click a tablespace name to view information on that tablespace's datafiles.