The answer to your question is YES, but you could get rid of the tablespace
completely by creating a new temp tablespace (new / different name
required), assigning all users to it (make it your default tablespace if you
are running 9i or +).
Then simply drop the old temporary tablespace.
--
Syltrem
OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Randi W" <randiwolner_at_hotmail.com> a écrit dans le message de
news:ckdvmf$897$1_at_services.kq.no...
> Oracle ver. 8.1.7, NT:
>
> I had a disk crash on the disk containing one of the datafiles in the TEMP
> tablespace. I have no backup routines on this database (yes, I know this
is
> stupid, so please do not comment on this).
>
> I managed to get my database running by using this command in svrmgrl:
>
> alter database datafile 'G:\ORADATA\ORAPOO1\TEMP02.DBF' offline drop;
>
> In v$datafile the status of this file is 'RECOVER'. My question is: Can my
> database 'live on' with the file having this status? As it is the TEMP
> tablespace I figure there is no data in the file at this time, and I can
add
> more files if more temporary space is needed.
> OR - will Oracle give error messages when trying to allocate more space in
> temp tablespace, and finding that one of the data files has 'RECOVER'
status
> ?
>
> Thanks for any help on this,
> Randi W.
>
>
Received on Tue Oct 12 2004 - 09:26:20 CDT
