Skip to Content
avatar image
Former Member

What is DataBase Reorganisation?

Dear Gurus,

What is DataBase Reorganisation and why? and let me know the procedure to reorganise the Oracle DB in R/3 environment.

ThanQ.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 08, 2007 at 12:26 PM

    A good reason for reorganization is converting tablespaces from Dictionary managed to locally managed.

    I would highly recommend reading SAP Note 646681 - Reorganizing tables with BRSPACE.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Yes, you are correct. That would be one of the few <u>valid</u> reasons ( IMHO )

      But is a "one" off action, once is done, it is not necessary to repeat it 😊

  • May 08, 2007 at 09:06 AM

    data gets inserted and deleted regularly but the inserted data does not always fit into the given space which resulted from deletion...so the data gets fragmented with ongoing time...you'll need to "de-fragment" the data...

    example: you'll do your archiving and lots of data gets deleted but the allocated space on disk is not freed...these gaps need to be removed...so all data will be 'extracted' and re-arranged into the given disk/table/tablespace with all data blocks being filled consecutively..one block after the other and no gaps...

    you'd use tools like sapdba/brtools to reorganize your oracle db...have a look at the respective sap documentation (oracle dba)

    GreetZ, AH

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 08, 2007 at 10:45 AM

    Hi,

    Usually, there is no "real" reason to justify a full database reorganization ( very time consuming )

    Why do you want to do one?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 08, 2007 at 12:20 PM

    Hi Andreas, Thanks for your help.

    Add comment
    10|10000 characters needed characters exceeded