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@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 - 02:22:17 CDT