Re: how to find out what tablespace objects belong in

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: Fri, 29 Sep 2000 08:28:31 -0400
Message-ID: <39D48AEF.A43D982@Unforgetable.com>

Verna Legaspi wrote:

> 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

Packages/Functions/Procedures are always stored in SYSTEM tablespace. You cannot control that. As for the rest:

select distinct owner,

                     tablespace_name,
                     segment_type,
                     segment_name

from dba_segments; Received on Fri Sep 29 2000 - 07:28:31 CDT