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
Tuesday, April 7, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment