Re: Where does Oracle store Stored Procedures?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/11/13
Message-ID: <34705329.17876865@newshost>#1/1

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.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Nov 13 1997 - 00:00:00 CST