Re: Where does Oracle store Stored Procedures?

In article <34705329.17876865_at_newshost>, tkyte_at_us.oracle.com says...
> On Thu, 13 Nov 1997 10:42:12 -0500, Suvamoy Sen <suvamoy_at_hotmail.com> wrote:
>
> >When a user creates a stored procedure in his schema, where does Oracle
> >store the stored procedures? whether in the user's default tablespace or
> >in the system tablespace. Can a user have control over the location of
> >the stored procedures? i.e. can he control which tablespace the stored
> >procedures gets written to?
> >Could anyone please give an answere. Thanks in advance
>
> They are compiled into (and stored in text format) the system's data dictionary
> which is in the SYSTEM tablespace. All procedures go into SYSTEM.
>
>
>

Specifically it can be viewed via USER_SOURCE, DBA_SOURCE, and ALL_SOURCE.

-- 

Bob Withers              Do or do not, there is no try.
bwit_at_pobox.com                                  Yoda