ORA-01653: unable to extend table

[Former Member]

Hi!

I'm having a lot of SPOOL_I/O_ERROR dumps and the main reason is the following:

ORA-01653: unable to extend table SAPPMP.TST03 by 8192 in tablespace

I'm checking on db02 the tablespace SAPPMP and I have the following:

Tablespace: PSAPPMP

Management: LOCAL

Allocation: SYSTEM

Init ext.(kb): 64

Next ext (kb): 0

Min ext: 1

Max ext: unlimited

What can I do?

Greetings,

Wadih Saad

[markus_doehr2 · Accepted solution]

Extend that tablespace using brtools.

--

Markus

[Former Member]

Hi,

Pl check if the tablesp is Autoextensible or not.

If not alter it Autoextension on via BRTOOLS -

---

>SPACE MANAGEMEN

Or extend the tblspace via BRTOOLS.

Regards

[Former Member]

Hi,

make sure the correspondening user has the right to extend the table.

<i>alter user $User$ quota unlimited on $tablespace$;</i>

[Former Member]

The problem were solved by manually extending the tablespace. But the problem is that the tablespace had the autoextend on.

I checked the datafiles of that tablespace and I viewed that a couple didn't have the autoextend on, so I beleive that causes the problem.

Thanks all for your answers,

Wadih Saad

[Former Member]

good answer

[Former Member]

Hi Wadih,

You have to ensure that Basis job SAP_REORG_SPOOL is scheduled.

This Job remove old spools from TST03 to make room for new spools.

If the job is already scheduled then you have to extend the Tablespace.

Maniss,