Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Staff member accidentally created new tablespace

    Staff member accidentally created new tablespace

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Staff Course Reserves module will not stay up
      • Staff Note doesn’t appear if added “after” Locate
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved