Re: SYSTEM Tablespace - condensing/compressing

Anthony Smith wrote:
>
> I would like to reduce our 3 data files for the SYSTEM tablespace
> into one. These have been create due a series of bad decisions
> and basically occupy to much space, as well as giving the
> inefficiencies of 3 files. I am reasonably conversant with doing
> this sort of thing for normal tablespaces, but playing with
> SYSTEM worries me. Anyone have a simple step by step guide. TIA.
> --
> Anthony Smith

Unfortunately, there is none that I know of. The only solution seems to export full your actual database, then drop it(!) and recreate it with CREATE DATABASE... size whateverMb you want your SYSTEM tablespace to be. The SYSTEM tablespace can never be turned offline (of course!) and that prevents any manipulation you could have on its files.

Sylvie Bérubé
sberube_at_aircanada.ca Received on Sun Jan 12 1997 - 00:00:00 CST