ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
SOL:
Check the default temporary tablespace first , execute the following query:
SQL> SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';
Now check the TEMP Tablespace used and free spaces as below:
SQL> select TABLESPACE_NAME, BYTES_USED, BYTES_FREE from V$TEMP_SPACE_HEADER;
TABLESPACE_NAME BYTES_USED BYTES_FREE
—————————— ———- ———-
TEMP 52428800 0
Now add datafile to temp tablespace or make it autoextendable
SQL>ALTER TABLESPACE temp ADD TEMPFILE '/data02/nsndb/temp02.dbf' SIZE 1024m;
NOTE:- If your datafile is in autoextend mode , just check there may be some bad written query can be the cause of the problem.