Corrupt datafile of TEMPORARY tablespace

Hi all,

in one of our databases (Oracle 8.1.7.0.0. SE / WinNT) an user accidentaly swiched the server off while it was doing a big SQL query (and nothing else!).
Now, database cannot start because temp datafile isn't as big as Oracle expect it would be. Autoexpand was on (on that datafile) and probably the datafile was expanding while user switched off the server.

I supose that information in temporary datafile isn't important at all for the rest of the data (another tablespaces).

My questions are next:

1. Is there any utility that can fix header of bad datafile?
2. Can I in any way put some other temp datafile in place of this one
   (created using exact same installation of Oracle, but with other SID, and in
   the same tablespace)?
3. What and where should I change in header in that "replacement" datafile
   (using hex editor)?
   I tried to do this, and done some experimenting, and manage to realize that among other things, header contains information of tablespace in which datafile belongs, SID of the database and, of course, block cheksums. Now, when I change those info (tblspace name and SID) dbverify reports that cheksum is invalid and compute the cheksum (I manage to find where it rests in file), but I can't change it since the checksum itself is used in calculation of cheksum (am I right?). Help.
4. Or there is another easy way to do it, and I'm just not aware of it?

Thanks in advance... Received on Fri May 24 2002 - 13:10:06 CDT