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,