Re: Where does Oracle store Stored Procedures?

From: Greg Parsons <parsons_at_intermetrics.com>
Date: 1997/11/13
Message-ID: <346B53DE.A8CD246@intermetrics.com>#1/1

SYSTEM tablespace contains stored procedures. From what I know, cannot be redirected to another tablespace. Why? Greg

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
Received on Thu Nov 13 1997 - 00:00:00 CST