临时表空间不够ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

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

查看临时表空间大小：

select tablespace_name,file_name,bytes/1024/1024 file_size,autoextensible from dba_temp_files;

给临时表空间加文件：

    alter tablespaceTEMP add TEMPFILE '/opt2/oradata1/temp07.dbf' size 30720m ;