Re: Re-sizing the SYSTEM tablespace

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 3 Feb 2000 21:45:26 +0100
Message-ID: <949610856.13783.0.pluto.d4ee154e@news.demon.nl>

Alter database datafile <name of the system tablespace datafile> resize 200M (or something, but 200 should definitely be adequate). You need to make of course there's no data beyond the 200M. This means, as it it the SYSTEM tablespace, you potentially can be forced into rebuilding the complete database. If this is 8i there seems to be an option to move extents. This option definitely doesn't exist in 7.3 and before.

Hth,

--
Sybrand Bakker, Oracle DBA
Lynux <lynux_at_netvigator.com> wrote in message news:87cksn$iq016_at_imsp212.netvigator.com...
> We come to a problem that we have created our user tables into the
> system tablespace. And now the tablespace is extended to nearly 2G
> of size.
> Our question is how can we shrink the SYSTEM tablespace into its normal
> size after all the user tables are moved to another tablesapce?
> Would someone give your suggestion on this?
> Thanks in Advance!
Received on Thu Feb 03 2000 - 14:45:26 CST