Re: extending tablespace TEMP

You can never remove a file from a tablespace once it's been added. You'll need to retrieve the file from backup, and perform recovery to it. As to extending your temp tablespace, assuming it is actually too small, just follow one of the three normal ways of making a tablespace bigger:

1. alter database datafile 'path/filename' autoextend on next 10m
2. alter database datafile 'path/filename' resize 1000m;
3. alter tablespace temp add datafile 'path/filename' size 1000m

(put your own sizes in as appropriate, of course).

Number 3 is preferred, but 1 has the advantages of simplicity.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================

"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.

>