Shulou(Shulou.com)06/01 Report--

Oracle 11.2.0.4.0

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

ORA-39171: Job is experiencing a resumable wait.

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

ORA-39171: Job is experiencing a resumable wait.

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

View temp tablespace

SQL > select file_name,bytes/1024/1024 "MB", autoextensible,tablespace_name from dba_temp_files

2

FILE_NAME

MB AUT TABLESPACE_NAME

-

/ data0/oracle/oradata/hldbm/hldbm/temp01.dbf

32767 YES TEMP

It has been automatically expanded to 32G, and the db_block is 8192 and DBF can only grow to 32G.

Solution:

Add tempfile to the temp tablespace and open autoextend in the file.

SQL > alter tablespace temp add tempfile'/ data0/oracle/oradata/hldbm/hldbm/temp02.dbf' size 1000m autoextend on

Tablespace altered.

SQL >

It may not be enough to add a tempfile here, depending on the amount of data imported. Because impdp imports logical data, it eats memory.

After the import is complete, release the temp space.

Release process:

Create temporary tablespace TEMP01

TEMPFILE'/ data0/oracle/oradata/hldbm/hldbm/tempfile01.dbf' SIZE 1000m

REUSE AUTOEXTEND ON

Alter database default temporary tablespace TEMP01

Drop tablespace temp including contents and datafiles

Create temporary tablespace TEMP

TEMPFILE'/ data0/oracle/oradata/hldbm/hldbm/temp01.dbf' SIZE 1000m

REUSE AUTOEXTEND ON

Alter database default temporary tablespace TEMP

Drop tablespace TEMP01 including contents and datafiles

So far, over!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.