Re: Where does Oracle store Stored Procedures?

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

Stored procedures are stored in the data dictionary in the system tablespace.

-- 
Wayne Linton
lintonw_at_cadvision.com