on 09-06-2011 12:41 PM
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
Hello,
yes - it is possible since BRSPACE 7.10 patch 24. More information in sapnote #1360603
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.