dropping tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: dropping tablespace

Hybrid View

  1. #1
    Join Date
    Feb 2000
    Posts
    1
    i am not able to drop the following tablespace.

    this tablespace has only one datafile, it so happened that the last extent that was allocated caused the datafile to grow from 7 gig to 9 gig.

    now the problem is because of this huge datafile the database does not allow any kind of write operation to the objects of that tablespace.

    read access is fine though.

    only option is to shudown abort the database.

    i have worked around this and relocated all of the data to another tablespace and things are fine with the old tablespace offline.

    how do i get rid of this tablespace without having to create a new database.



    Oracle 7.3 workgroup server on NT 4.0.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Check any other rollback segments are created in the tablespace. If so, you need to drop those segments and then drop the tablespace.

  3. #3
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    Just a note to make sure...

    If you drop the tablespace, you still need to go out and physically delete the associated datafiles, Oracle wouln't do this for you.

    _________________________
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.
    (877)687-3227

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width