TEMP tablespace - URGENT...

[jovery]

There is a simpler way to 'coalesce' a temporary type tablespace

First switch the tablespace back to permenant

alter tablespace xxx permanent;

Then coalesce the tablespace

alter tablespace xxx coalesce;

Lastly switch the tablespace back to temporary

alter tablespace xxx temporary;

Using this method you do not have to create any additional datafiles or drop any.

Regards