Segment can cause table space overflow

[Former Member]

Hi ,

I am getting the follwoing error .

Table: SAPR3.RKEPI, value: 1024000 KB * 2 / PSAPCLUI (> 2047994/1023994/1023994/1023994/57542 KB) # Segment can cause tablespace overflow.

I have checked the previous messages, but couldn't find an appropriate answer. I have extended the tablespace to 10 datafiles but still the problem continues. The % of table space is 50%.

Please help me to solve .

thanks,

ram

[stefan_koehler · Accepted solution]

Hello Ram,

how big are the datafiles that you were adding to the tablespace PSAPCLUI (and with which autoextend clause)?

The critical error message says, that you have not enough contiguous space in your tablespace to keep the next extent size of 1024000 KB * 2 (= 2GB).

In your case you only have the following contiguous free space in your tablespace:

2047994 KB < 2048000 KB

1023994 KB < 2048000 KB

1023994 KB < 2048000 KB

1023994 KB < 2048000 KB

57542 KB < 2048000 KB

>> The % of table space is 50%

In this case the % is not important.. you need to have round about 2 GB contiguous free space in your tablespace.

Regards

Stefan

[Former Member · Accepted solution]

Hi Stefan,

What i need to do now. I am totally confused. Please help,

thanks,

[stefan_koehler · Accepted solution]

Hello,

> What i need to do now. I am totally confused. Please help,

That depends on what you have already done - you need more free space in one big part (round about 2 GB).

Unfortunately you didn't answer my question:

• How big are the datafiles that you were adding to the tablespace PSAPCLUI (and with which autoextend clause)?

Regards

Stefan

[Former Member · Accepted solution]

The size of data files is 2GB.

thanks,

[former_member185954 · Accepted solution]

Hello Rama,

You should consider doing a tablespace REORG of your affected TABLESPACE.

Regards,

Siddhesh