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

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.

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply