Tuesday, April 7, 2009

Drop Undo Tablespace

To drop the undo tablespace (undotbs) issue the following statement,

SQL> Drop tablespace undotbs including contents and datafiles;

The statement will return error if the undo tablespace have any active transactions or any unexpired extents.

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