cancel
Showing results for 
Search instead for 
Did you mean: 

What is the purpose of having auto extend of table space?

Former Member
0 Kudos

Hi Basis Experts,
I want to know the purpose of having auto extend concept in extending table space.
Why can't we just allocate a large amount of memory at once instead of extending it each time when its full.
Please explain
Many thanks in advance.


Accepted Solutions (1)

Accepted Solutions (1)

former_member188958
Active Contributor
0 Kudos

If you only have a single databases on the system it would make sense to just allocate it everything.  Auto extend is more for systems where there are multiple databases that would be growing at different (and presumably unpredictable) rates and a finite pool to free disk space to distribute among them.

Former Member
0 Kudos

Hi,

Auto extend is helpful when you don't want to keep on adding space in a tablespace.

Say you have 4 tablespace created on a single FS, you cannot go an allocate large space to a single tablespace rather you keep them on AUTO EXTEND ON, so that they use FS space as and when required.

Allocating large space to a tablespace can be a solution but after sometime the table space will be full and again you will have to go and add space to it. Auto extend is a kind of automation when it comes to adding space to a table space.

Regards

Prithviraj.

Answers (0)