Re: Temp01.dbf deleted. Is recovery possible?

startup mount
alter database create datafile 'temp01.dbf' as 'temp01.dbf' alter database mount;

I think that's what it is, from memory.

Or else you can always do
startup mount
alter database datafile 'temp01.dbf' offline drop; alter database open

and repair afterward (recreate a new temp)

-- 
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---
"gserdijn" <gserdijn_at_koper-it.nl> a écrit dans le message de
news:d7e2b32f.0312170815.5feffc39_at_posting.google.com...


> System: Windows 98

> DB: Personal Oracle 8.1.6

>

> A customer deleted temp01.dbf. He has no backups available. Now the

> database cannot start up.

>

> Is it possible to fix this problem?

>

> Please advise.

>

> Gerry