Re: how to find out what tablespace objects belong in

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 19 Sep 2000 08:11:21 +0200
Message-ID: <969370616.29354.1.pluto.d4ee154e@news.demon.nl>

pl/sql code is stored in the data-dictionary, in the source$ table (with the dba_source, all_source, and user_source view on top of it), so that's the reason why you don't see it.
The tablespaces of objects are stored in dba_segments, dba_extents, dba_tables, dba_indexes, dba_clusters and so on.

Hth,

Sybrand Bakker, Oracle DBA

"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 - 01:11:21 CDT