How to Increase the Tablespace free space?
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


Questions
Do you have a SAP Basis Question?

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.