Reorg database to recover database space

[Former Member]

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

[anindya_bose · Accepted solution]

Prakash

Go through the below link...

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

[Former Member]

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

[Former Member]

Hi Experts

I have successfully reorganised database after client deletion.

Thanks a lot for all your inputs.

Best Regards

Prakash.P

[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

[Former Member]

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

[former_member204746]

read SAP note 646681.

[lbreddemann]

>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