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