- Article Type: General
- Product: Aleph
- Product Version: 18.01
One of our staff members used UTIL O | 17 | 1 thinking it was instead UTIL O | 13 | 3 and added a tablespace called UNDOTBS04. They were trying to add space to UNDOTBS1. How can we delete that new tablespace since it won't be used for anything but is still taking up space?
Log in as root
> su -oracle
SQL*Plus: Release 22.214.171.124.0 - Production on Mon Mar 15 10:42:23 2010
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter user-name: /as sysdba <----------------------------
Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> DROP TABLESPACE UNDOTBS04
Your DBA should do this.
- Article last edited: 10/8/2013