on 05-08-2007 9:15 AM
Dear Gurus,
What is DataBase Reorganisation and why? and let me know the procedure to reorganise the Oracle DB in R/3 environment.
ThanQ.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andreas, Thanks for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Usually, there is no "real" reason to justify a full database reorganization ( very time consuming )
Why do you want to do one?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.