Previous  Index  Next  How To Use

You can reach the Tablespace Manager via the Enterprise Manager and the Storage. Double clicking the Tablespaces node will open a window similar to the one below.


The Oracle Tablespace Manager


The list displays the currently available tablespaces, their status and current size. From here, you can create new, edit or drop tablespaces.


When editing or creating a new tablespace, use the OK button to save your changes and the Cancel button to cancel your changes.



The user you used to register the server needs to have access to views DBA_TABLESPACES, DBA_FREE_SPACE, DBA_DATA_FILES and DBA_TEMP_FILES for this feature to work.


Create New Tablespace

Using the New Tablespace button will open up a dialog similar to the one below:


Tablespace Dialog, page 1


On the first page, you can enter the tablespace name and size properties. Mind you, the available options depend on whether some other options are set. eg: Pct Increase is only available when Dictionary extent management is selected.


Tablespace Dialog, page 2


On the next page of the dialog, you can create new datafiles or remove datafiles (while the tablespace is still "new"). Each datafile can have sizing properties. If the tablespace is an existing tablespace, the current size will be displayed next to the filename.


When editing filenames, make sure that the filename specification is local to the server.


For more information regarding the available tablespace options, see the Oracle documentation.


Edit Tablespace

Many options cannot be modified and are either disabled or read-only. Usually, datafiles cannot be removed unless they're still "new".


Drop Tablespace

Use the Delete Tablespace button to remove a tablespace from your Oracle Database. Database Workbench does not yet support dropping a tablespace including its contents, so attempting to do that will raise the following error:


ORA-01549: tablespace not empty, use INCLUDING CONTENTS option