Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Jesus OreFeb 4 2025

Hello everyone,

I have a problem when I run this import script:

nohup $ORACLE_HOME/bin/impdp system@orap directory=DIR_DRP dumpfile=test.dmp table_exists_action=TRUNCATE exclude=statistics > 0102.log &

One of the table gave this error while import. The error is related to TEMP table space being not sufficient.

Checking the log appears these:

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

ORA-39171: Job is experiencing a resumable wait.

To solve this issue I created a second temp tbs and included in temp group

CREATE TEMPORARY TABLESPACE temp2 TEMPFILE 'temp02.dbf' SIZE 5M AUTOEXTEND ON TABLESPACE GROUP temp_grp;

Add main temp to temp group

ALTER TEMPORARY TABLESPACE temp TABLESPACE GROUP temp_grp;

But when I ran it again it doesn't work, your thoughts.

Regards,

Comments
Post Details
Added on Feb 4 2025
5 comments
441 views