On Tue, 18 May 2004 08:51:18 -0500, "Jenny Wang"
<jennyw_at_housing.tamu.edu> wrote:
>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
>
- the database doesn't need to be in restricted mode
- the change is effected immediately
--
Sybrand Bakker, Senior Oracle DBA
Received on Tue May 18 2004 - 13:58:12 CDT
