Tablespaces used by XI?

[Former Member]

Hi everybody,

the database of an XI installation consits of a couple of tablespaces.

PSAP<SID>

PSAP<SID>640

PSAP<SID>DB

PSAP<SID>USR

PSAPTEMP

PSAPUNDO

SYSTEM

Does anybody know the purpose of each table space?

Especially: Where are the messages (Adapter Engine and/or Integration Server) stored?

So which tablespaces are expected to grow?

Regards,

Marc

[former_member187339]

Hi Marc,

PSAP<SID> = All objects of the SAP component <SID>. Example: PSAPC11.

PSAP<SID>USR = Customer-specific objects for component <SID>. Example: PSAPC11USR.

PSAPTEMP = Temporary obejcts (system default temporary tablespace)

PSAPUNDO = Undo tablespace (used from Oracle 9i instead of PSAPROLL)

Go thru this link, it might be useful :

http://help.sap.com/saphelp_nw04/helpdata/en/9f/4a56b2185851468b39b719daa2d3aa/frameset.htm

Regards

Suraj