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 in SYSTEM. Read the sql.bsq file in $ORACLE_HOME/rdbms/admin ( I think, if not there then look in $ORACLE_HOME/dbs). It creates the dictionary tables at CREATE DATABASE time and that's where you can see the exact table where it is kept. If you want to change that table's tablespace, you're out of luck: at CREATE DATABASE time you only have SYSTEM active....

Of course, you can try to do it later by moving some of the SYS tables somewhere else, but you're on your own and I never said this. <G>

-- 
Nuno Souto
nsouto_at_NOSPAMacay.com.au