huge table reorganize with BRSPACE

[Former Member]

Hello,

our system is under 46C with oracle 10G and Brtools 7. we have a big table with 800Gb partitioned into 12 partitions, so now we have to reorganize it. my question:

- we can use BRSPACE to reorganize just one partition?

Thank you for your help

[stefan_koehler]

Hello,

yes - it is possible since BRSPACE 7.10 patch 24. More information in sapnote #1360603

Regards

Stefan

[Former Member]

Hello Stefan,

thank you for your response, but this sap note is valid just for

from SAP_BASIS 71 to 730

[stefan_koehler]

Hey,

that's just a misleading labeling, because of it refers to the BR*Tools version.

You can use the BR*Tools 7.10 with your current release (check sapnote #1060305 for confirmation) and so you can reorganize partitions only.

Regards

Stefan

[Former Member]

Hello,

Brtools 7.10 can be/is being used with NW 7.0 as well. Depends on Oracle version.

Note 12741 - Current versions of BR*Tools and SAPDBA

The BR*Tools 7.00/7.10 can be used for all SAP releases that run with an Oracle 10g database, or an Oracle 9.2 database after installing the Oracle Instant Client 10g on the Oracle 9.2 database server. For more information, see Note 849483.

The BR*Tools 7.20 can be used with all SAP releases that run with an Oracle 10g or 11g.

Thanks

[volker_borowski2]

Hello,
> yes - it is possible since BRSPACE 7.10 patch 24. More information in sapnote #1360603
> 
> Regards
> Stefan

Hi,

you might need a higher patchlevel, if the table is hash partitioned.

I had a call for that, because the syntax of the DDL was garbled for hashpartitioned tables (128 partitions).

If I remember correctly i got a patched version ahead of time, which was PL 31+, so I think you should ensure to be at least on PL 32.

Be sure to set an initial extent category for brspace, otherwise it might be too big.

Volker

[Former Member]

Hi,

Thank you for your response,

My table have 12 Partitions, the big one is 800GB.

- is there any size limit with brspace?

- what you mean please by extent category for brspace?

- i have created a tablespace for reorg (900GB), my SPAPTEMP is fixed to 157GB, do you think that is OK or i have to increase PSAPTEMP?

Thank you for your help