topic Tablespaces in SAP in Application Development and Automation Discussions

Tablespaces in SAP

Former Member — Sat, 02 Feb 2008 06:17:42 GMT

Hi,

I was made to understand that there is only two tablespaces in SAP - one for data and the second one for Index. Can we have more than two tablespaces?

Thanks,

Manjula.

Re: Tablespaces in SAP

Former Member — Sat, 02 Feb 2008 08:20:58 GMT

Hi manjula,

Yes, you can add whatever custom tablespaces you want. As a matter of fact, this is a recomendation from SAP. If you have VERY large tables, they should be on tablespaces of their own.

There are a couple of different scenarios:

1. Large custom tables that need a seperate tablespace (in case you don't want to keep them in PSAPUSERxx).

2. Large SAP tables that you want to manage seperately.

You can check SAP documentation or the OSS notes and below link for further assistance..

http://sapbasis.wordpress.com/2007/08/14/checking-sap-r3-tablespaces/

pls reward if helps,

regards.

Re: Tablespaces in SAP

Former Member — Sat, 02 Feb 2008 08:55:34 GMT

Hi,

Yes, you can add whatever custom tablespaces you want. As a matter of fact, this is a recomendation from SAP. If you have VERY large tables, they should be on tablespaces of their own.

You can add custom tablespaces if there is a need.

There are a couple of different scenarios:

1. Large custom tables that need a seperate tablespace (in case you don't want to keep them in PSAPUSERxx).

2. Large SAP tables that you want to manage seperately.

You can check SAP documentation or the OSS notes for further assistance.

Reward Points if found helpfull..

Cheers,

Chandra Sekhar.