Skip to Content
avatar image
Former Member

Reorganising Table space after client delete BRTOOLS/BRSPACE

Hi All,

I am looking to reorganise the SAP tablespaces after I have deleted a client as part of my learning excercise(I am running out of disk space on the harddisk). As you can imagine I am fairly new to this field. All help appreciated.

The version of SAP is ECC 6.0 with ABAP 702, BASIS 702.

Look forward to hearing from the SAPers.

Thanks.

Manish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 23, 2012 at 12:41 PM

    Hi Manish,

    As guided in note 35952, when the clients are deleted the blocks are
    allocated as free, however these are not yet visible as freespace yet.
    You will need to perform a reorganization to resolve this.
    Regarding reorganization, please kindly check the following notes:


    Note 541538 - FAQ: Reorganization
    Note 646681 - Reorganizing tables with BRSPACE
    Note 53062 - Database reorganization and data archiving

    See also SAP Note 821687 - FAQ: Space utilization and fragmentation in Oracle

    for details.

    Let us know if questions persist.

    Regards,

    Paul

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Manish,

      One quick point. You mentioned that there is no one using the database at present.

      In that case, an offline reorg would complete faster as it would have all the locks it needs on tables during reorg without worrying about users being acitve and changing the tables being reorged.

      Please go through the admin guides and also the notes provided and experiment on a sandbox system to get a feel for the process. Do feel free to revert back with any open issues.

      Regards,

      Paul