TBTCO grows and grows

[christian_laber2]

Hello guys,

today I get a lot of short dumps with:

"ORA-01631: max # extents (300) reached in table

SAPR3.TBTCO?"

--> I have raised up the extents but now my question:

How I can reduce the size of this table???

Thanks

Christian

[JPReyes · Accepted solution]

You need to delete the old background jobs by scheduling SAP_REORG_JOB, is part of the housekeeping jobs, these will trigger program RSBTCDEL.

Read,

http://help.sap.com/saphelp_nw70/helpdata/en/c4/3a7fef505211d189550000e829fbbd/content.htm

And

http://help.sap.com/saphelp_nw70/helpdata/en/c4/3a7ede505211d189550000e829fbbd/content.htm

Regards

Juan

[Former Member · Accepted solution]

Hello,

Verify if you are running all standard jobs that are recommended by SAP in the note 16083.

Hope this helps!

Best regards,

Rafael Toshiaki

PS: Please consider rewarding points for helpful answers on SDN.

[Former Member]

check if standard job RSBTCDEL can clear some old job logs

Samrat