MCQs>IT & Programming>Oracle 9i Administration>You have two undo tablespaces defined for your database. The instance is currently using the undo tablespace named UNDO_TBS1. You issue the following command to switch to UNDO_TBS2, while there are still transactions using UNDO_TBS1: ALTER SYSTEM SET UNDO_TABLESPACE = undo_tbs2 What will be the result?
Oracle 9i Administration MCQs
You have two undo tablespaces defined for your database. The instance is currently using the undo tablespace named UNDO_TBS1. You issue the following command to switch to UNDO_TBS2, while there are still transactions using UNDO_TBS1:
ALTER SYSTEM SET UNDO_TABLESPACE = undo_tbs2
What will be the result?
Answer
Correct Answer: New transactions are assigned to UNDO_TBS2
Explanation:
Note: This Question is unanswered, help us to find answer for this one