Re: Reducing System Tablespace Size

From: Barry Jones <jonesb_at_logica.com>
Date: 14 Oct 1998 13:56:59 GMT
Message-ID: <01bdf77a$804135f0$1811ea9e@ukp01758>

I thought stored procedures resided in the system tablespace. The more stored procedures ....
Also wrapping any stored procedures just about doubles the space required in the system tablespace.

Barry Jones
Logica UK Ltd.

satar_at_my-dejanews.com wrote in article <6vg9mg$6v6$1_at_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
>

rest deleted Received on Wed Oct 14 1998 - 08:56:59 CDT