Skip to Content
avatar image
Former Member

Reorg database to recover database space

Hi

After performing client deletion, how to do "reorg database to recover database space"? Kindly let me know the steps to proceed further...

Environment

SAP 4.6C

Oracle 10G

Windows 2003 X64

Thanks & Regards

Prakash.P

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Best Answer
    Sep 08, 2009 at 07:31 AM

    Prakash

    Go through the below link...

    It contains the note number, SQl statement etc...

    table-space-reorganization-quick-expert-inputs

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 08, 2009 at 06:41 AM

    >Kindly let me know the steps to proceed further...

    How about 'kindly read the documentation/sap notes you find by searching for "reorganisation"'?

    Man, what is wrong with reading the docs?

    All the time somebody opens threads that basically say 'go, do my job, I don't want to invest the 5 minutes to read the docs myself'.

    Is that really what you want? Always rely on somebody even for the easiest tasks?

    Don't you want to become a bit more independent by trying to get as far as possible by yourself and then ask for help if it is still necessary?

    regards,

    Lars

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 08, 2009 at 01:20 PM

    read SAP note 646681.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 10, 2009 at 02:33 AM

    Hello,

    Some Hints:

    You can reorg the tables in the same tablespace if you have enough space with Brspace

    If not you should move the tables to other tablespace.

    You can reorg tables and index online exception tables having long & long row columns

    All information needed is at sap note 646681

    Hope it helps..

    Regards,

    sapcrosas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 11, 2009 at 07:33 AM

    Hi Experts

    I have successfully reorganised database after client deletion.

    Thanks a lot for all your inputs.

    Best Regards

    Prakash.P

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Prakash,

      I also have the same issue, can you please let me know how have you achieved reorganization.

      I also have deleted a client but the space space is still occupied in the database.

      Please let me know.

      Thanks

      Harikrishna

  • avatar image
    Former Member
    Mar 01, 2013 at 01:31 PM

    Hi, Prakash.

    In addition to what was already suggested, you may look at Index Compression feature of Oracle Database Enterprise Edition. Here is the wonderful example of results - http://www.oracle.com/us/products/database/ocs-nl20-national-foods-396165.pdf?goback=%2Egmp_4809717 and

    http://www.oracle.com/technetwork/database/performance/sapstorageoptimization-335322.pdf and links from sap community:

    http://scn.sap.com/community/oracle/blog/2008/04/21/oracle-index-key-compression

    Hope this will help you even more 😉

    Cheers,

    Evgeny

    Add comment
    10|10000 characters needed characters exceeded