ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP

Problema

BR0301E SQL error -1652 in thread 3 at location tab_onl_reorg-26, SQL statement:

'CREATE UNIQUE INDEX "SAPR3"."MLCRP~0#$" ON "SAPR3"."MLCRP#$" ("MANDT", "BELNR", "KJAHR", "POSNR", "BDATJ", "POPER", "CURTP")

  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

  STORAGE(INITIAL 16384 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

  TABLESPACE "PSAPBTABI" '

ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP

Solução

- Faça um extend na PSAPTEMP e altere os datafiles para auto extend.