| 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
Sajid
The error indicates that you have permanent objects stored in your temporary tablespace.
Try issuing the following command to identify these objects:
SELECT segment_name, segment_type
FROM dba_segments
WHERE tablespace_name = 'TEMP'
You need to remove all permanent objects from the temporary tablespace
before making
it of type temporary as this type is what prevents permanent objects from
being stored in it.
You may either have to move the objects to a different tablespace by making
a copy of it
in a different tablespace, dropping the original and then renaming the copy.
Hope this info helps!
Regards
Natasha
----- Original Message -----
From: "Sajid Iqbal" <siqbal_at_vianetworks.co.uk>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Thursday, January 04, 2001 9:20 AM
Subject: temp tablespace
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 Liststo: 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). Received on Thu Jan 04 2001 - 20:17:25 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |