Staff member accidentally created new tablespace

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph
Product Version: 18.01

Description:
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?

Resolution:
Log in as root
> su -oracle
> sqlplus

SQL*Plus: Release 11.1.0.7.0 - Production on Mon Mar 15 10:42:23 2010

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Enter user-name: /as sysdba <----------------------------

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Then do:

SQL> DROP TABLESPACE UNDOTBS04
INCLUDING CONTENTS
CASCADE CONSTRAINTS;

Your DBA should do this.

Article last edited: 10/8/2013