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, and then the online search, found the following workaround: Create a new temporary tablespace.

First you have the system permission, log in,

The first step is to create a table space, such as the following, d in quotation marks is the drive letter, ORACLEORADATATESTDBTEMP01 is the file name, 100m is the size,

TEMP01 is a temporary space name that can be modified.

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

The second step, change the database temp table space, is the original update to the new

ALTER DATABASE default temporary tablespace temp01;

Step three, delete the original temporary table space

Drop Tablespace temp;

After the following modification, ora-25153 error can be resolved, but if the first step, the size value is too small, it will be reported ora01652 cannot pass 128.

Here, modify it properly.

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

The size value in the.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

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