Bizarre ORA-25153: Solutions for temporary tablespace being empty

Recently report data source switch to the query database, the query reported ORA-25153: Temporary tablespace is empty, it is strange, some queries have problems, some normal, switch to the business database Normal. The system database www.2cto.com is divided into business databases and query databases, and the consumer uard is used. Later, it was found that the temporary tablespace in the query database exists, and the corresponding temporary data file does not exist. The default temp is still there, but the business database is normal. The user specified a temporary tablespace to create the temporary tablespace. When a temporary tablespace is created on the business database during initialization, the temporary data file is not automatically synchronized to the query database. This means that the query database has a temporary tablespace, but the corresponding temporary data file is missing, some complex queries require the use of temporary tablespace to query and store some buffer data. It is normal to report an error. Previously, temporary data files in the business database were manually copied to the query database, but cannot be identified;

Modify the temporary tablespace of the current user to the built-in TEMP, and the query returns to normal. Author sunway0628