Re: Dropping Users?

From: Cathryn Symons <cathryn_at_unisys.co.nz>
Date: Mon, 12 Dec 1994 22:24:38 GMT
Message-ID: <1994Dec12.222438.19428_at_unisys.co.nz>

Lawrence James (James.Lawrence_at_epamail.epa.gov) wrote:

: DROP USER <user> CASCADE; will get rid of the user and any objects he/she : owns.

Be aware that if you are using DROP USER CASCADE with 7.0, it does not necessarily free up the space occupied by the users objects. According to Oracle support here this is fixed in 7.1

The objects disappear from the data dictionary (eg. dba_tables, dba_indexes) but the space they occupied is not released. If you check dba_free_space, it has not appeared there.

According to Oracle's bug number 160602, the space should be cleaned up eventually, but I waited some days before dropping the tablespace. I had dropped a user with a large number of objects (about 500).

The workaround is to explicitly drop all the user's objects.

I saw this on 7.0.16 under Solaris 2.4, but believe it to be a generic problem.

Regards,

Cathryn

---

Cathryn Symons					phone ++64 4 4984622	
Information Systems Consultant			fax   ++64 4 4984800
Unisys New Zealand Ltd				email cathryn_at_unisys.co.nz

P. O. Box 3240
Wellington New Zealand

---

-- 


================================================================================

Cathryn Symons					phone ++64 4 4984622	
Information Systems Consultant			fax   ++64 4 4984800
Unisys New Zealand Ltd				email cathryn_at_unisys.co.nz

Received on Mon Dec 12 1994 - 23:24:38 CET