Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Staff member accidentally created new tablespace

    • 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
    //Feedback