It might happen that because of upgrade of
BW system, maintenance activities, inconsistencies etc. you need to reorganize temporary
BW objects. These kinds of objects are starting with following name convention:
/BI0/0X*
Where X means different temporary object
given by specifics circumstances which occurred when the object was created. E.g.
/BI0/06* are tables used during BEx query processing. Refer to SAP Note 449891 for more
object types.
If you face situation that you are running
out temporary objects you can delete temporary object. You can use report SAP_DROP_TMPTABLES
to reorganize them. Report deletes them pretty straight forward with checking
either they are used at the runtime of report. Therefore it is advisable to run
this report as a part of maintenance activities in defined time frame when no
regular activities are happening in the BW system. Make sure no user is running
queries, no data load is happening, no compression is in place etc.
Notice that report’s runtime is depended on
how big your system is. In general if you going to run it for first time it
might be that it will run for several hours.
Furthermore you can use function module RSDDTMPTAB_CLEANUP
(while specifying input parameter I_NAMETYPE = 03) for the same as well.
See other SAP notes on topic of Temporary
database objects in BW:
1139396 -
Temporary database objects in BW 7.X
449891 - Temporary
database objects in BW 3.x
659946 - FAQ:
Temporary tablespaces
More
information:
