How to Increase the Tablespace free space?

• 
• 

Details

Category: Basis

Published on Saturday, 06 March 2010 22:49

Written by SAP Basis

Hits: 3943

Your tablespace PSAPBTABD is 92% used. How do you increase the free space?

SAPDBA V3.1I - SAP Database Administration
____________________________________________________________________________
ORACLE version : 7.3.4.3.0
ORACLE_SID     : ALD
ORACLE_HOME    : /oracle/ALD
DATABASE       : open
SAPR3          : 31H, 23 times connected

a - Startup/Shutdown instance    h - Backup database
b - Instance information         i - Backup archive logs
c - Tablespace administration j - Check (and repair) database
d - Reorganization               k - Restore/Recovery
e - Export/import                l - Show/Cleanup
f - Archive mode                 m - User and Security
g - Additional functions         n - Help
q - Quit

Please select ==>  c
____________________________________________________________________________


Tablespace administration
____________________________________________________________________________

Current value
a - Tablespace:
b - Log checks:                                 no

c - Free space and fragmentation  of all tablespaces
d - Check   free space of objects in all tablespaces
e - Check   free space of objects in tablespace

f - Alter   tablespace Add Datafile
g - Create/drop tablespace

h - Display all tablespaces and datafiles
i - Display raw device drivers in /dev

q - Return

Please select  ==>  a

Enter tablespace name [%] ==> psapbtabd
____________________________________________________________________________

Tablespace administration
____________________________________________________________________________


Current value
a - Tablespace:                                 PSAPBTABD
b - Log checks:                                 no

c - Free space and fragmentation  of all tablespaces
d - Check   free space of objects in all tablespaces
e - Check   free space of objects in tablespace PSAPBTABD

f - Alter   tablespace PSAPBTABD Add Datafile
g - Drop    tablespace PSAPBTABD

h - Display all tablespaces and datafiles
i - Display raw device drivers in /dev

q - Return

Please select  ==>  f
____________________________________________________________________________
Alter tablespace PSAPBTABD add datafile
____________________________________________________________________________

Current value

a  -  File system or raw device:   file system
b  -  File size:                   2088960 K (larger than free space)
c  -  Select path:                 /oracle/ALD/sapdata5
d  -  Alter suggested path:        /oracle/ALD/sapdata5
free space: 3608 K
e  -  Display current files:       10 files, total (in DB): 77


s  -  Start (Add datafile)

q  -  Return

Please select  ==>  s

• < Prev
• Next >