First, check whether temp is the default tablespace SelectUsername, Temporary _ Tablespace for some users from DBA _ Users. If the user's default temporary tablespace is temp, it is suggested to change Alter User XXX temporary tablespace tempdefault and set it as the default temporary tablespace alter database default temporary tablespace TempDefault. Then delete the table space temp, including content and data files, with the statements you listed; Even if all temporary tablespaces are lost, as long as the statements that consume temporary tablespaces, such as order by, Sub-query, group by, distinct, etc. , are not used in the database (and if it needs to be large or small, you can use pga's SORT_AREA area area directly), so the business will not be interrupted by errors, and you only need to create a temporary tablespace after finding the problem. If you know about backup recovery, in fact, temporary tablespaces will not be backed up when they are backed up, but there is only a statement to create temporary tablespaces.