Re: how to find out what tablespace objects belong in

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