Also vote for B & D.
SQL>alter system set undo_management=manual scope=spfile;
Bounce instance.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string MANUAL
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> alter system set undo_tablespace='UNDOTBS2';
alter system set undo_tablespace='UNDOTBS2'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-30014: operation only supported in Automatic Undo Management mode
https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm
You can switch from using one undo tablespace to another. Because the UNDO_TABLESPACE initialization parameter is a dynamic parameter, the ALTER SYSTEM SET statement can be used to assign a new undo tablespace.
ALTER SYSTEM SET UNDO_TABLESPACE = undotbs_02;
BD - correct
ALTER SYSTEM SET UNDO_TABLESPACE = UNDOTBS01;
show parameter undo
NAME TYPE VALUE
------------------------ ---------- ---------
temp_undo_enabled Boolean FALSE
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS01
This section is not available anymore. Please use the main Exam Page.1z0-082 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Asmodeus
Highly Voted 3 years, 2 months agodoyinbare
Most Recent 7 months, 4 weeks ago[Removed]
2 years, 7 months agoMandar79
3 years, 8 months agoNowOrNever
3 years, 7 months agoMandar79
3 years, 8 months agoEkos
3 years, 4 months ago