Re: PL/SQL Location

From: Joel Garry <joelga_at_pebble.org>
Date: Fri, 26 Jun 1998 23:15:45 GMT
Message-Id: <slrn6p8avb.fn7.joelga@pebble.org>

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.
>
>Many thanks,
>Dan.
>

If you grep for DBA_SOURCE in a full export file, you'll see a hint:

CREATE PUBLIC SYNONYM "DBA_SOURCE" FOR "SYS"."DBA_SOURCE" And, if you are suitably empowered, you can:

> describe sys.dba_source

 Name                            Null?    Type
 ------------------------------- -------- ----
 OWNER                           NOT NULL VARCHAR2(30)
 NAME                            NOT NULL VARCHAR2(30)
 TYPE                                     VARCHAR2(12)
 LINE                            NOT NULL NUMBER
 TEXT                                     VARCHAR2(2000)

jg
--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Fri Jun 26 1998 - 18:15:45 CDT