Re: Deferred Segment Creation

Perfect, thank you Jonathan.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Principal Consultant at Pythian
Oracle ACE Alumni
Pythian Blog http://www.pythian.com/blog/author/still/ Github: https://github.com/jkstill

On Thu, Feb 25, 2021 at 11:45 AM Jonathan Lewis <jlewisoracle_at_gmail.com> wrote:

>
> Jared,
>
> If you check the view dba_tables you'll see that it joins tab$ to
> deferred_stg$ on obj#, and then there are lots of columns which use
> when (bitand(t.property, 17179869184) = 17179869184)
> in a case statement to decide whether to use seg$ or deferred_stg$ to
> report segment-related information (like INITIAL, NEXT, etc.)
>
> So if you can get object_id from dba_objects for object_type = 'TABLE'
> (et. al.) then you could join that to deferred_stg$ on obj# to see if a row
> exists there - and if it does then the table was declared as deferred.
>
> Regards
> Jonathan Lewis
>
>
>

--
http://www.freelists.org/webpage/oracle-l