Re: how to find out what tablespace objects belong in

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 19 Sep 2000 17:22:17 +1000
Message-ID: <39c705ae$1_at_news.iprimus.com.au>


Packages and procedures are stored in the data dictionary (so you can expect to find them in the SYSTEM tablespace), unless you get into developing them as C external libraries (in 8i, for example)

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



"Verna Legaspi" <vlegaspi_at_uswest.net> wrote in message
news:SnDx5.1315$qD6.567516_at_news.uswest.net...

> Is there a way (script?) to find out what tablespace objects such as
package
> bodies & headers belong in? the dba_segments does not seem to report this
> information.
>
> TIA,
> Verna
>
>
>
Received on Tue Sep 19 2000 - 09:22:17 CEST

Original text of this message