on 09-07-2010 10:27 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.