You dont want to back out of data changed in every

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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. Incorrect Answers: 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 database. 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 QUESTION 95: Why does the command cause an error? Exp system/manager i...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online