cancel
Showing results for 
Search instead for 
Did you mean: 

BW - order table spaces

Former Member
0 Kudos

Hi,

Some body know how I can distribute tablespaces in PSA/ODS, CUBES, DIMENSIONS.

When transport an ODS, this object automatically be placed on a specific tablespace (to ODS).

Thanks very much.

Victoria

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Search for these terms 'TABART' 'TAORA'

When you look at table TAORA, then you will find an entry like

TABART  TABSPACE    
DODS    PSAPSR3ODS  

This means all ODS objects go to the tablespace PSAPSR3ODS. There are entries for dimensions and fact tables as well.

You should start with note [771191 - Copying BW objects to new tablespaces|https://service.sap.com/sap/support/notes/771191]

But be warned, it is easy to create a mess, especially if you have partitioned objects with many dimensions.

Good luck, Michael

Answers (0)