Re: questions about system tablespace

ALL PL/SQL code goes into datadictionary tables and thus in the system tablespace. Designer 2.1 60M of pl/sql packages. Beware!

Sybrand Bakker, Oracle DBA

Robert Hart wrote:

> Eric Junkermann wrote in message <36758dba.10862888_at_news.demon.co.uk>...
> >
> >Good Grief!
> >
> >You should not be putting tables for any application in the system
> >tablespace, especially one whose growth is essentially unpredictable.
> >Designer has lots of stored code, which of course goes into the system
> >tablespace, but the install guide makes specific recommendations about
> >this. Putting any application data in SYSTEM is almost a guarantee of
> >future problems.
> >
> >Regards,
> >
> >
> >Eric.
>
> OK
>
> I agree with you on never putting application data in the
> system tablespace. There is also the one about a default
> tablespace and a temp tablespace.....
>
> BUT
>
> I seem to recall that when I worked with some of the oracle
> products I was advised to create a product tablespace for
> product tables, etc.
>
> I still follow that practice. Is there some new trick that
> requires you to put product tables in the system tablespace
> or are you talking about package, procedure, function code
> that is stored there?
>
> Robert Hart

Received on Mon Dec 21 1998 - 14:23:41 CST