This preview shows page 1. Sign up to view the full content.
Unformatted text preview: it needs to be backed up.
You don't want to back out of data changed in every tablespace, just this one. You can
use incomplete recovery on a tablespace in order to revert to the version of data that
existed just prior to the problem. For this task, you will need to create a second database
on this or another machine, export the table on the second database, and import it back to
the original. Creating this second database, sometimes referred to as a clone, is a main
part of performing tablespace incomplete recovery.
A: It does not allow the export to recover statistics on the tables.
Actualtests.com - The Power of Knowing 1Z0-025
B: Is used for different purposes, not to prevent accidental corruption of the primary
C: It does not allow the SYSTEM tablespace to become a transportable tablespace.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 713-714
Chapter 15: Advanced Topics in Data Recovery
Why does the command cause an error?
Exp system/manager i...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09