SAP Library - Find your answers

Your 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