Skip to Content
Former Member
Jul 16, 2009 at 08:16 AM

Less PSAPTEMP space consumption when activating DSO



I hope someone can help us with the following question:

We are loading 11 million sales data sets into a DSO. The activation of the request fails with ORA-12801: error signaled in parallel query server ...# ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP".

Our PSAPTEMP is 8 GB. I checked the SDN (result see below), but before I increase the table space, I like to know, whether

the data load can be made less space consuming.

a) Is the table space uncommonly small?

b) Can the activation be made less parallel?

c) How to do so (configuration in SAP BW or data base level)?

d) Does the activation in this case need less space?

e) Da we easily split up the data load using different DTPs?

Best regards


SDN research:

see next post