New Features for Administrators - Question 045

What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?

A. It is NOT possible to switch unless no active transaction exists in UNDO1.

B. It is possible to switch to UNDO2, but current active transactions will abort.

C. It is possible to switch to UNDO2; current active transactions will be automatically migrated to UNDO2.

D. It is possible to switch to UNDO2; only current active transactions will continue to execute inside UNDO1

Answer: D

Explanation:

You can switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2. Only current active transactions will continue to execute inside UNDO1, all new transactions will be assigned to the new undo tablespace.

Incorrect Answers

A: You can switch undo tablespaces while active transactions will run in the old undo tablespace. All new transactions will be assigned to the new undo tablespace.

B: Current active transactions will abort if you switched undo tablespaces.

C: Current active transactions will continue to execute inside UNDO1 till they commit or roll back. They will not be automatically migrated to UNDO2.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 160-166

Chapter 3: Manageability Enhancements

Oracle 9i New Features, Robert Freeman, p. 19-25

Chapter 1: Oracle9i Database Administration and Management Features