Can't drop Tablespace???

From: David Hiltz <dhiltz_at_whsun1.whoi.edu>
Date: Sun, 21 Feb 93 16:19:24 GMT
Message-ID: <1993Feb21.161924.16676_at_netnews.whoi.edu>

    I'm trying to drop a tablespace, but whenever I issue the DROP command,     it just hangs.

    The tablespace, called ROLLBACK_SEGS, is used to hold my two rollback     segments. I've gone through all the steps: created a temp rollback     segment in the SYSTEM tablespace, dereferenced the two rollback segments     in ROLLBACK_SEGS, bounced the database, took the ROLLBACK_SEGS     tablespace offline. However, I can't drop the ROLLBACK_SEGS tablespace.

    I'm running Oracle 6.0.36 on a Sun SS2.

    Any ideas would be greatly appreciated, thanks.

    If responding by email, use "dhiltz_at_whsun1.wh.whoi.edu"

---

    David Hiltz
    NMFS/NOAA, MA
    dhiltz_at_whsun1.wh.whoi.edu
    ######&_at_&######

--

    David Hiltz
    NMFS/NOAA, MA
    dhiltz_at_whsun1.wh.whoi.edu

Received on Sun Feb 21 1993 - 17:19:24 CET