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

Home -> Community -> Usenet -> c.d.o.server -> alter tablespace ... temporary

alter tablespace ... temporary

From: Jenny Wang <jennyw_at_housing.tamu.edu>
Date: Tue, 18 May 2004 08:51:18 -0500
Message-ID: <c8d4cm$inf$1@news.tamu.edu> 





Currently our TEMP tablespace is permanent in our 8.1.5. server. We need to
change it to temporary. When issue "alter tablespace ... temporary", can
Database be in normal system operation or has to be in restricted mode.
Also, when does the tablespace change from permanent to temporary take
place, after instance starts next time?



Thanks in advance.



Jenny


jennyw_at_housing.tamu.edu
Received on Tue May 18 2004 - 08:51:18 CDT












Original text of this message













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