Good Morning Gurus,

I have two problems for your expert dissection.

One: We have a student that deleted an entire table. I have a backup
that is just a little over a week old. Is there any way to recover just
that table from the backups instead of having to recover the entire
database? Can this be done without using the import/export mechanism?

Two: I have been making output files from this database for a couple of
weeks now. During the accounting phase (accounting in the sense of
checking the integrity of the files and making sure everyone/everything
is present in the files) I am finding that data that was entered
previously, is now not found in the database. I know that a commit was
done post-load of each datafile. Could it be that if a tablespace file
was full/maxed out, that the data would, in essence, disappear? Or would
I get some message upon loading that the data could not be loaded for
lack of space?

I cannot discount that something might have happened while the student
was remote logged in that caused a mishap in the loading. But I don't
have enough experience to understand what happened and why.

Thank you very much,
La Vonne Mangin
Univeristy of Iowa
Center for Statistical Genetics Research

Oracle LazyDBA home page