Managing Oracle UNDO Tablespace / Rollback Segments
https://oracle-dba-online.com/managing_the_undo_tablespace.htm
Switching to Automatic Management of Undo SpaceAltering Undo TablespaceDropping An Undo TablespaceSwitching Undo TablespacesViewing Information About Undo TablespaceYou 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. The following statement switches to a new undo tablespace: ALTER SYSTEM SET UNDO_TABLESPACE = myundo2; Assuming myundo is the current und…See more on oracle-dba-online.com 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. The following statement switches to a new undo tablespace: ALTER SYSTEM SET UNDO_TABLESPACE = myundo2; Assuming myundo is the current und…
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. The following statement switches to a new undo tablespace: ALTER SYSTEM SET UNDO_TABLESPACE = myundo2; Assuming myundo is the current und…
DA: 39 PA: 6 MOZ Rank: 76