extending tablespace TEMP

From: Jan Eliasen <eliasen_at_cs.auc.dk>
Date: Tue, 18 Dec 2001 10:54:42 +0100
Message-ID: <Pine.GSO.4.33.0112181052020.4488-100000@borg.cs.auc.dk>

Hi there.

How do I do that? I'm trying to do a simple

select * from h2alle one, h2alle two where one.dato = two.dato;

but I get an error;

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

How do I fix this? I can't find any information about it.

Oh, and I have added a datafile to the SYSTEM tablespace. Does anyone know how I delete it from the tablespace again? I have accidently deleted the file on the harddrive, but I can't seem to find a way to remove it from the tablespace?!?

-- 
Eliasen Jr.

Received on Tue Dec 18 2001 - 03:54:42 CST