Tablespace Administration with SAPDBA 
Use
You can use SAPDBA for Oracle to administer tablespaces.
Prerequisites
You know how to use SAPDBA and have set it up correctly. Refer to
Getting Started with SAPDBA.
Features
Check for free space and fragmentation in a single tablespace or all tablespaces
Display the assignments of tablespaces to datafiles or raw devices
Display raw device drivers
Add datafiles to extend existing tablespaces
Create new tablespaces or drop empty tablespaces
Activities
You choose Tablespace administration from the SAPDBA main menu.
You
check tablespaces regularly, distinguishing between the following main problems:
- The tablespace is highly fragmented, requiring a
reorganization
The tablespace has too little free storage space, requiring an extension (see below)
SAPDBA records the performed checks in the
<timestamp>.ext
log, when you have set the
Log checks option to yes. See
Setting the Log Checks Option.SAPDBA always logs the extension of a tablespace or the creation of a new one.
- If necessary, you
extend an existing tablespace.
If necessary, you
create a new tablespace or drop an existing one.
If you have created or extended a tablespace, you
back up the database.
If necessary, you can
display file and raw device information for a tablespace.