A temporary tablespace is full.

Background of a temporary tablespace full problem: in our company, we have a dedicated demonstration environment. During pre-sales, we can use the above system for demonstration. Problem: today, when our manager demonstrated to the customer, the system suddenly reported: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP ORA-06512: at "BEMS. PKG_RPT_180101 ", line 12 ORA-06512: at line 1 Analysis: Baidu from the Internet, or look at the ORACLE online help documentation, it is easy to know that this is a temporary tablespace is insufficient. So let's check the temporary tablespace: 1. view table space SQL> select file_name, bytes/1024/1024 "MB", autoextensible, tablespace_name from dba_temp_files; the query results show that there is currently only one temporary table space, although it can grow by itself, but it is 32 GB and the max size has been reached. The problem has been quite clear. Considering that the customer is demonstrating the problem, it is necessary to quickly restore the system to normal. Solution: 1. create a new temporary tablespace SQL> create temporary tablespace temp02 tempfile '/home/oracle/oradata/bemsdemo/temp03.dbf' size 512 M; 2. switch the current default tablespace to the new tablespace SQL> alter database default temporary tablespace temp02; 3. delete the original temporary tablespace SQL> drop tablespace temp including contents and datafiles; 4. recreate the original temporary tablespace SQL> create temporary tablespace temp tempfile '/home/oracle/oradata/bemsdemo/temp01.dbf' size 512 M autoextend on maxsize 32G; 5. switch the default temporary tablespace back to SQL> alter database default temporary tablespace temp;