Re: extending tablespace TEMP

> 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?!?

Yes it's possible - but only when no extents where allocated in that datafile ...
I'm not going to post the procedure because it involves deleting records from the core data dictionary tables and thus, is not supported by Oracle (allthough I've seen them doing it myself) ....

Anyhow if you do want to whack that datafile - just look for the procedure on deja/google (I posted it before)

"Jan Eliasen" <eliasen_at_cs.auc.dk> wrote in message news:Pine.GSO.4.33.0112181052020.4488-100000_at_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 - 06:06:32 CST