A USER ERROR HAS OCCURRED, BUT THE EFFECTS ARE LIMITED TO ONE TABLESPACE

8. A user error has occurred, but the effects are limited to one tablespace. You

want to flash back this one tablespace, but not the others. What must you do?

(Choose the best answer.)

A. Execute ALTER TABLESPACE . . . FLASHBACK OFF for all the other

tablespaces, then flash back the database.

B. Take the other datafiles offline, flash back the database, and bring the

other datafiles online.

C. Flash back the whole database, then do complete recovery of the other

tablespaces.

D. It is not possible to flash back one tablespace and leave the rest of the

database current.