Re: How to descrease size of System Tablespace?
From: Doug Barnes <dwb_at_rell. <dwb_at_rell.">
Date: 1998/01/12
Message-ID: <69d8h1$f8_at_ux1005.rell.com>#1/1
Date: 1998/01/12
Message-ID: <69d8h1$f8_at_ux1005.rell.com>#1/1
Heinz Waldherr wrote:
>
> Hi,
>
> I have to reorganize an Oracle 7.3 database.
>
> The problem is thatup to now all tables have been stored in the System
> tablespace.
> Therefore it has grown to the extent of 2.6 GB. Although I have moved all
> the stuff to other tabelspaces now, and there are only the SYS and SYSTEM
> related stuff left,
> I still can't resize the datafile ('file contains xxx blocks of data beyond
> requested RESIZE value'). Which seems a bit odd, as there's only 15 MB of
> data left.
>
> Anybody knows an easy way to get a normal SYSTEM file and tablespace?
>
> Thanks
>
> Heinz
You'll probably have to export the entire DB-remake the DB with the sizes you want and import your data.
-- Remove the NOSPAM to E-mail me. Tired of the MLM schemes.Received on Mon Jan 12 1998 - 00:00:00 CET