Re: Deferred Segment Creation
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Thu, 25 Feb 2021 19:44:54 +0000
Message-ID: <CAGtsp8mcsd-5AeJKhAzFiqbHbYrkeQM3y_FCn7xzEZsf+iev1Q_at_mail.gmail.com>
Date: Thu, 25 Feb 2021 19:44:54 +0000
Message-ID: <CAGtsp8mcsd-5AeJKhAzFiqbHbYrkeQM3y_FCn7xzEZsf+iev1Q_at_mail.gmail.com>
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
Received on Thu Feb 25 2021 - 20:44:54 CET