Re: How to descrease size of System Tablespace?

You're probably getting this error because the 15M that's being used may be spread across the space that was initially allocated for the SYSTEM tablespace. Try coalescing the tablespace first: alter tablespace SYSTEM coalesce. Look at free space: select bytes from sys.dba_free_space where tablespace_name='SYSTEM' order by bytes; and you will see the amount of free space in the tablespace. Now resize the tablespace based on the largest amount of free space available.

Hope this helps.

In article <69d8h1$f8_at_ux1005.rell.com>, dwb_at_rell."<"NOSPAM says...
>
>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