Skip to Content
Former Member
Mar 14, 2007 at 05:06 PM

Multiple vs 1 Tablespace


We are in the process of building our prod environment and our databases are going to be very Big, around 5-6TB. So far we have been using the default SAP implementation and we have been putting all the objects in either PSAPSR3 or PSAPSR3700 tablespace. Now we are almost ready to build the Prod and I was wondering if it would be beneficial to go with the traditional Tablespace layout by SAP where you have multiple tablespaces or should we just stick to one large tablespace..Please suggest!