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_at_news.demon.nl>
Date: Tue, 19 Sep 2000 08:11:21 +0200
Message-ID: <969370616.29354.1.pluto.d4ee154e_at_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 - 08:11:21 CEST