Re: Compact SYSTEM tablespace?

Hello Benjamin,

No, SYSTEM tablespace you can only reorg with a full export/create db / import.
Which is not what you want to do probably. However u can take a look and see what is up there at the end of the file with the Frag.sql scripts on my site:

   www.bytelife.com/sql4dba.htm

Then drop this object; move it or rebuild it (don't drop any stuff from SYS or SYSTEM!)

Good luck

     Roelof Schierbeek

R.Schierbeek, DBA
e-mail: info_at_nSpammbytelife.com
www : www.bytelife.com

Benjamin Johnston <superhero_at_benjaminjohnston.com.au> schreef
> Hello,
> I used Oracle for some rather large data processing, but did so in the
> SYSTEM tablespace instead of creating a new tablespace. I now realize my
error.
>
> Unfortunately, now that I have dropped the large amount of data involved,
I
> cannot shrink the tablespace down to a reasonable size again (it seems
that
> some other data has been written to a position late in the file). While I
> can live with the wasted space... the machine isn't dedicated to the DBMS,
> so I'd like to reclaim as much disk space as I can if it is at all
possible.
>
> The Oracle documentation indicates that I need to take a tablespace
offline
> to compact it... but, that didn't sound like a good idea when it comes to
> the SYSTEM tablespace.
>
> So, is it possible to compact the SYSTEM tablespace, without doing
anything
> too dramatic?
>
> Thanks for any assistance,
>
> -Benjamin Johnston
Received on Sun Dec 22 2002 - 09:36:41 CST