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.