How to Increase the Tablespace free space?

our tablespace PSAPBTABD is 92% used. How to 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

No comments:

topics