Skip to Content
0
Apr 24, 2009 at 02:32 AM

ORA-1652: unable to extend temp segment by 128 in tablespace for PSAPTEMP

376 Views

We got ORA-1652 for PSAPTEMP tablespace

Enviroment: Oracle 10.2.0.2

But in DB02, psaptemp 's free space is 100%

The max index /table size is 1.4G/2.9G

Even we add PSAPTEMP to 10G, still get same error. The error show every hour.

Any suggestion for this issue?

Thanks a lot.