DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2000
    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
    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
    Oxford, OH
    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.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.