ORA-1652: unable to extend temp segment

Hi,

Context :

1) Production database : 11.2.0.4, Windows server

TEMP tablespace file size = 4 Gb

TEMP tablespace file max size = 4 Gb

A business batch ran every day and terminates successfully (15 days a go the batch failed with

ORA-1652: unable to extend temp segment by 512 in tablespace

)

2) Test database :

same version than production

same TEMP tablespace file size and max size

Since production data have been imported in test database, the batch fails with :

ORA-1652: unable to extend temp segment by 512 in tablespace

TMP

Solutions provided :

1) The temp datafile max size is limited to 4 GB, I removed that limit on test environment following (TROUBLESHOOTING GUIDE (TSG) : ORA-1652: unable to extend temp segment (