I am a new dba, testing the backup and recovery strategy for our new database, which will go live in a few months. I have a feeling that most of our problems will be in trying to undo user errors. We will be running in ARCHIVELOG mode, and performing complete offline backups each night, as well as hot backups daily at noon. Is there an easy way to recover just an individual table? Most of the recovery methods I've found involve taking an entire tablespace offline, which in our case, would mean most of our users wouldn't have access until the recovery is complete.

We are in an NT environment, with Oracle 8.0.5.

I would really appreciate any advice you have to offer.

Dawn