Re: PL/SQL Location

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sat, 27 Jun 1998 04:06:38 GMT
Message-ID: <6n1r42$ja0@bgtnsc01.worldnet.att.net>

On Fri, 26 Jun 1998 16:12:28 +0100, Dan Benwell <danbenwell_at_dial.pipex.com> wrote:

>Does anyone know where PL/SQL i.e. the souce
>and p-code is held in Oracle. I know I can see it
>through the data dictionaries so does this mean that
>it is stored in the SYSTEM tablespace or the default
>for the user.

I would bet it depends on who owns the object. Since Oracle has to enforce quotas and such, it would make sense for each user's objects to end up in their default tablespace.

I could be wrong though<g>. Received on Fri Jun 26 1998 - 23:06:38 CDT