Multiple choice technology databases

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

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

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

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

  4. It is possible to switch to UNDO2; only current active transactions will continue to execute inside UNDO1.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When switching undo tablespaces in Oracle, you can switch to a new undo tablespace while active transactions continue using the old one. Only new transactions will use the new undo tablespace. Active transactions will complete in UNDO1 until they finish or the undo tablespace is taken offline.

Keep practicing — related questions