Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> temp tablespace

temp tablespace

From: Sajid Iqbal <siqbal_at_vianetworks.co.uk>
Date: Thu, 4 Jan 2001 13:16:20 +0000 (GMT)
Message-Id: <10731.125700@fatcity.com> 





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


Received on Thu Jan 04 2001 - 07:16:20 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US