Re: Reducing System Tablespace Size

From: MMK Productions <nospammmkprod_at_bellatlantic.net>
Date: Tue, 6 Oct 1998 21:17:17 -0400
Message-ID: <6vefgm$s3f@world6.bellatlantic.net>

Run some queries to test the total size of the objects in the data files which make up the SYSTEM tablespace. Then you can use the RESIZE option option to reduce the size of the data files.

Example

SYSTEM file1.dbf 9000 used 40000 size SYSTEM file2.dbf 4000 used 8000 size

I can reduce file2.dbf by 25% and still leave room. More of the same for file1.dbf.

Essam Elsherif wrote in message ...
>Is there a way to reduce the size of the system tablespace on ORACLE 8.0
>without recreating the database?
>
>Essam
>
>
Received on Tue Oct 06 1998 - 20:17:17 CDT