Re: Reducing System Tablespace Size

From: <satar_at_my-dejanews.com>
Date: Wed, 07 Oct 1998 17:51:13 GMT
Message-ID: <6vg9mg$6v6$1@nnrp1.dejanews.com>

ALTER DATABASE DATAFILE '/u01/oradata/y2k/system01.dbf' RESIZE 100M;

Really, you shouldn't need to change the size of this tablespace because Oracle should be the only person/thing to use it. Make sure there are no sorts, data, or user activity taking place on that tablespace.

Satar Naghshineh

In article <OpQ0iFX89GA.346_at_nih2naac.prod2.compuserve.com>, "Essam Elsherif" <eelsherif_at_wtgi.com> wrote:
> Is there a way to reduce the size of the system tablespace on ORACLE 8.0
> without recreating the database?
>
> Essam
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Oct 07 1998 - 12:51:13 CDT