Skip to Content
avatar image
Former Member

TABLE SPACE REORGANIZATION !! QUICK EXPERT INPUTS

HI.....Experts

We have a internal quick project of Reorganizing the our ABAP SCHEMA Table Space PSAPSR3 of Size 2 TB.

May i request you to give some quick check points / notes / links / advises to make it successfull.

We have to execute this to this weekend - request all to spare 2 seconds to reply this message.

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 09, 2009 at 03:41 PM

    Hi Friend

    Check the following notes.

    SAP Note 646681 - Reorganizing tables with BRSPACE

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

    Get the information about fragmented tables from your EWA report.

    Decide according to your database version. Post here if you have any question.

    Thanks and Regards

    Anindya

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Jyothi,

      hope you did your reorg activity successfully as i can gather from the posts. i have a similar situation with oracle 10g/ECC6.0 on windows 2003 platform. i am planing to do the extra client deletion followed by reorganization of whole database. Can you please guide/share your recent experience in doing tablespace reorganization.

      i have no good experience on oracle, please share your experience/document. waiting for your response.

      thank you.

  • avatar image
    Former Member
    Jul 09, 2009 at 03:46 PM

    Jyothi,

    If you search by term "table reorg" in sdn you will get many threads.

    Anyway see below sap notes & links

    SAP Note 646681 - Reorganizing tables with BRSPACE

    SAP Note 541538 - FAQ: Reorganization.

    reorg-complete-database

    steps-for-table-level-reorganisation

    https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70c8f19f-8010-2c10-ac89-8d828039d8b4

    https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70c8f19f-8010-2c10-ac89-8d828039d8b4

    Hope this helps you.

    Thanks

    Sushil

    Add comment
    10|10000 characters needed characters exceeded