oracle-015:ora-25153 temporary tablespace is empty, ora01652 cannot pass 128

Wrote a complex SELECT statement, suddenly Oracle reported: ora-25153 temporary table space is empty, this error, so online check the next. Found an example of the following workaround: Create a new temporary tablespace.

First, you have system permissions. After logging in,

The first step is to create a table space. For example, the D in the argument is a drive letter, ORACLEORADATATESTDBTEMP01 is the file name, 100m is the size,

TEMP01 is a temporary space name that can be changed.

Create temporary tablespace temp01 tempfile ' d:oracleoradatatestdbtemp01.dbf ' size 100m;

The second step. Changes the database temporal table space. is to update the original to the new

ALTER DATABASE default temporary tablespace temp01;

The third step, delete the original temporary table space

Drop Tablespace temp;

After doing such as the following changes, ora-25153 error can be conquered, but assuming the first step, the size value is too small, it will be reported ora01652 cannot pass 128.

Here's a proper change.

Create temporary tablespace temp01 tempfile ' d:oracleoradatatestdbtemp01.dbf ' size 100m;

The size value in the can.

oracle-015:ora-25153 temporary tablespace is empty, ora01652 cannot pass 128