| 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
--openmail-part-187aa3e3-00000001
Content-Type: text/plain; charset=US-ASCII
Content-Disposition: inline
;Creation-Date="Thu, 4 Jan 2001 08:35:19 -0600" Content-Transfer-Encoding: 7bit
select owner, segment_name from dba_segments
where tablespace_name = 'TEMP';
If anything is found, you'll need to relocate it.
-----Original Message-----
From: siqbal [mailto:siqbal_at_vianetworks.co.uk]
Sent: Thursday, January 04, 2001 7:20 AM
To: ORACLE-L
Cc: siqbal
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 - 08:35:21 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |