ORA-01652: unable to extend temp segment by 128

ora-01652: unable to extend temp segment by 128

Error occurred due to temp table-space is full. You need to add new temp file in your tablespace.

Solution

Following are the steps to add temp file in the TEMPORARY tablespace.

1. Check the temp file location and tablespace name for temporary tablespace.

col tablespace_name for a10
col file_name for a50
select tablespace_name,file_name from dba_temp_files;

TABLESPACE FILE_NAME
---------- ----------------------------------
TEMP D:\ORACLEXE\ORADATA\XE\TEMP01.DBF

2. Check the space on your operating system

3. Add a new temp file to the location.

alter tablespace TEMP add tempfile 'D:\ORACLEXE\ORADATA\XE\TEMP02.DBF' size 100m autoextend on next 100m;

Note: Check the tablespace name and datafile location before adding it in database.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.