Tuesday, April 7, 2009

Switching Undo Tablespace

Oracle Database can have more than one Undo tablespace, but only one undo tablespace will be online per instance. To switch the undo tablespace,

SQL> Alter system set Undo_Tablespace = 'undotbs2' scope=both;

Note: The active transactions will continue to use the old undo tablespace. The status of the old undo tablespace will be PENDING OFFLINE. The undo tablespace cannot be dropped when its status is pending offline. When all the active transactions are completed then the staus will be changed to offline. The new transactions will use the new undo tablespace.

Thanks

No comments:

Followers

Powered By Blogger
 

Oracle Database Administration. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com