ORA-03212: Temporary Segment cannot be created in locally-managed tablespace

Hi all,

I'am trying this SQL statement with SQL Plus

SELECT * FROM Customer ORDER by Name;

and getting this error message:

ORA-03212: Temporary Segment cannot be created in locally-managed tablespace

If I'm not using the ORDER by in my statement everithing is OK.

Can anyone tell me how to avoid this error message.

Tnx

Denis. Received on Wed Jan 30 2002 - 09:33:26 CET