Re: How to descrease size of System Tablespace?

If the system tables (SYS schema) are not fragmented, it could be as simple as doing a

ALTER DATABASE DATAFILE 'xxx.dbf' resize 20m;

this will resize the datafile xxx.dbf to a size of 20m. Can shrink and grow a file like this. Cannot shrink below highwater mark in file.

Heinz Waldherr <HWaldherr_at_mediavest.de> wrote in article <01bd1f4d$e17c1430$07a0a8c0_at_metalhammer>...
> 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
>
Received on Mon Jan 12 1998 - 00:00:00 CET