physical disk space after ORACLE reorganization with brtools

[Former Member]

Hi all! .

I perform reorganization after arсhiving with brtools. In db02 shows that free size in tablespace are increased but physical disk space not changed.

Can i make changes in online with brtools to increase physical disk space in reorganized tablespaces?

system ver. : ECC 5.0, oracle 9.2.0.7.0, BRTOOLS 6.40 (52)

Thanks for help!

Edited by: Andrey Burakov on Jun 14, 2011 7:39 AM

[Former Member · Accepted solution]

Hi all! . 
> I perform reorganization after arсhiving with brtools. In db02 shows that free size in tablespace are increased but physical disk space not changed. 
> Can i make changes in online with brtools to increase physical disk space in reorganized tablespaces?  
> system ver. :  ECC 5.0,   oracle 9.2.0.7.0, BRTOOLS 6.40 (52)
> Thanks for help! 
> 
> Edited by: Andrey Burakov on Jun 14, 2011 7:39 AM

Hi Andrey,

You need to reorganize whole tablespace, not only tables in order to reclaim the free space to the OS.

The prerequisite for online reorganization is:
Oracle 9.2 database or higher.
The prerequisite for online conversion of the LONG-fields into LOB-fields:
Oracle 10g database or higher.
Online conversion is supported for SAP kernel 7.00 or higher. For SAP kernel 6.40,
it is supported only in a restricted manner (see "Caution" in point III). Conversion is 
not supported for SAP systems with a kernel lower than 6.40.

Check the note 646681 - Reorganizing tables with BRSPACE

Best regards,

Orkun Gedik

Edited by: Orkun Gedik on Jun 14, 2011 9:10 AM

[Former Member]

Maybe this article is helpful in addition to the note mentioned.

Link: [BRSPACE Online Reorganizations: Top Ten Pitfalls and Problems|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/70cf010d-0b01-2d10-86a2-a0636c39a06e]

Edited by: Gerd Kirchner on Jun 14, 2011 1:13 PM

[Former Member]

Thanks

[Former Member]

Hai...

This happens some time, just re-execute the DBCheck i.e. Check database from DB13 one or two times, you will get the required result.

Cheers

KHS

[Former Member]

DBcheck was run many times after the reorganization.

Reorganization performed only with objects which have been archived. Not entire DB.

Maybe Orkun right. Probably needs to be done reorganizing the entire database

[Former Member]

DBcheck was run many times after the reorganization. 
> Reorganization performed  only with objects which have been archived. Not entire DB. 
> Maybe Orkun right. Probably needs to be done reorganizing the entire database

It is obvious that in order to reclaim the space to the OS, after the data have been archived, you have to reorganize the tablespace.

Best regards,

Orkun Gedik

[Former Member]

Thank you very much Orkun. Your help is very useful!

[Former Member]

You'r welcome my friend