Re: drop user hangs

Rainer Herbst wrote:

> Howard J. Rogers schrieb:
> > "Rainer Herbst" <rherbst_@_rz.uni-potsdam.de> wrote in message
> > news:bicqd3$rd2$1_at_zeppelin.rz.uni-potsdam.de...
> >
>
> There might be a problem because of the SYSTEM tablespace is filled to
> 98%,
> <snipped>
> --
> ------------------------------------------------
> Rainer Herbst Linux - Registered
> ZEIK User #319157
> Universität Potsdam Usual disclaimers applies!
> ------------------------------------------------

Why? There should be nothing in the SYSTEM tablespace other than the catalog and stored code from procdures, functions, packages, and triggers: Rarely more than a few hundred MB.

Run the following:

SELECT table_name
FROM dba_tables
WHERE owner NOT IN ('SYS', 'SYSTEM','WMSYS', 'OUTLN') AND tablespace_name = 'SYSTEM';

SELECT index_name
FROM dba_indexes
WHERE owner NOT IN ('SYS', 'SYSTEM','WMSYS', 'OUTLN') AND tablespace_name = 'SYSTEM';

There shouldn't be anything.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)