cancel
Showing results for 
Search instead for 
Did you mean: 

BW Tablespaces

henry_jones
Participant
0 Kudos
181

Does anyone know what BW type stuff goes into what default tablespaces? This is my guess:

PSAPBWP InfoObjects

PSAPBWP620 3.x Datasource PSA's

PSAPBWP700 7.X Datasource PSA's

PSAPBWPDIM InfoCube Dimension

PSAPBWPDIMI InfoCube Dimension Indexes

PSAPBWPFACT InfoCube Facts

PSAPBWPFACTI InfoCube Fact Indexes

PSAPBWPODS ODS / DSO

PSAPBWPODSI ODS /DSO Indexes

PSAPBWPUSR ??

PSAPROLL ??

PSAPSR3DB ??

PSAPTEMP ??

PSAPUNDO ??

SYSAUX ??

SYSTEM ??

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos
henry_jones
Participant
0 Kudos

Thanks but do you thnk my other guesses are correct?

Answers (1)

Answers (1)

Former Member
0 Kudos

I think your other guesses are pretty good. Some of the tablespace setup is system dependent, so it is however your Basis person set them up when you implemented.

We only have 10 tablespaces, and don't have any differentiation such as PSAPFACT and PSAPFACTI (we just have PSAPFACT). If you wanted to verify that the PSAPODSI tablespace only had indexes for you fact tables, you could run DBO2Old and then do a detailed analysis on that tablespace. If you only see indexes in it, then your guess is correct.

Michael