cancel
Showing results for 
Search instead for 
Did you mean: 

What is DataBase Reorganisation?

Former Member
0 Kudos

Dear Gurus,

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

ThanQ.

Accepted Solutions (1)

Accepted Solutions (1)

former_member204746
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Andreas, Thanks for your help.

Former Member
0 Kudos

Hi,

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

Why do you want to do one?

andreas_herzog
Active Contributor
0 Kudos

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