Re: Reducing System Tablespace Size

From: <satar_at_my-dejanews.com>
Date: Wed, 14 Oct 1998 19:18:16 GMT
Message-ID: <702tdo$hq$1@nnrp1.dejanews.com>

You're right, stored procedures are located in the data dictionary which resides in the SYSTEM tablespace. In article <01bdf77a$804135f0$1811ea9e_at_ukp01758>, "Barry Jones" <jonesb_at_logica.com> wrote:

> 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
>

--
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 14 1998 - 14:18:16 CDT