Re: I'm doomed, right?

I would go for a full database export to /dev/null. This will physical verify all the user data, and most of the data dictionary.

It is possible that
a) your count(*) from some bizarre reason

     is using your damaged temp tablespace     (I suggest dropping it and recreating it     at some point)

b) Your count(*) is using an index - in which

    case you may have sound data, but a corrupt     index which you can drop and rebuild. Check     the execution plan for the count(*).

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.