# Storage Manager

This tool provides an easy interface to administrate tablespaces and datafiles.

As you can see in the screenshot above the tool is a list of all the tablespaces available in the database. The tablespaces can be expanded to display the datafiles they consist of. There is also one option available to this tool, whether to collect information about how coalesced the tablespaces are, the coalesced fetching can be very slow on fragmented databases and if TOra seems to lock itself when you try to start this tool try resetting that option to not show coalesced info. Using the toolbar you can perform these commands.

Refresh | Update the view.
Tablespace online | Take the selected tablespace online.
Tablespace offline | Take the selected tablespace off-line.
Enable tablespace logging | Enable logging for the selected tablespace.
Disable tablespace logging | Disable logging for the selected tablespace.
Read write tablespace | Enable read and write access to the selected tablespace.
Read only tablespace | Only allow read only access to the selected tablespace.
Modify tablespace | Modify the selected tablespace settings. If you don't understand the settings in this dialog please refer to the Oracle Server Concepts manual.
Modify datafile | Modify the current datafiles settings. If you don't understand the settings in this dialog please refer to the Oracle Server Concepts manual.
Add tablespace | Create a new tablespace. If you don't understand the settings in this dialog please refer to the Oracle Server Concepts manual.
Add datafile | Create a new datafile for the currently selected tablespace. If you don't understand the settings in this dialog please refer to the Oracle Server Concepts manual.
Coalesced tablespace | Coalesced free data in the current tablespace.
Move datafile | Move a datafile to another location.
Change connection | Change the connection to administrate storage for.

When you select a tablespace or datafile the lower part of this tool displays the objects (to the left) and extents (to the right) in that tablespace or file. A used extent is displayed as green in the extent view if the object it belongs to is not selected in the list to the right. Selecting an item in the list to the right will paint it's extents red in the right extent view. Unallocated space is colored whie. Some information about the number of files and extents are displayed at the top of the extents display. Several datafiles are separated by one line of black in the extent view if a tablespace containing several files are viewed.