| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: temp tablespace
someone has used this tablespace to create an object, until you empty it,
you can't change it to temporary (and that unable to extend error has
nothing to do with whether the tablespace is permanent or not)...
do the following:
select segment_name from dba_segments where tablespace_name ='TEMP';
this will give you a list of the objects in that tablespace. You then have to move and/or drop them. Once that's done, make sure that no one has quota on the temporary tablespace (so they cannot create something else before you finish)... then you can alter the tablespace to temporary.
The unable to extend error means you don't have enough space in your temporary tablespace to accomplish the sort or join or index creation etc that you are trying to do.....
>From: Sajid Iqbal <siqbal_at_vianetworks.co.uk>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: temp tablespace
>Date: Thu, 04 Jan 2001 05:20:27 -0800
>
>Hello
>
>I am trying to change my temporary tablespace to be temporary as its
>permanent at the moment.
>
>This has been highlighted be errors such as unable to extend temp segment
>in tablespace temp !
>
>When i try to make the chage I get the following error !
>
>ERROR at line 1:
>ORA-01662: tablespace 'TEMP' is non-empty and cannot be made temporary
>
>Any ideas
>
>
>
>--
>Sajid Iqbal
>Database Administrator
>
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Sajid Iqbal
> INET: siqbal_at_vianetworks.co.uk
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
 |
 |