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

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

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 possible to switch to UNDO2; only current active transactions will continue to execute
inside UNDO1.

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

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, but current active transactions will abort.



Leave a Reply 0

Your email address will not be published. Required fields are marked *