From: Mladen Gogala <>
Date: Thu, 27 Oct 2011 02:04:45 +0000 (UTC)
Message-ID: <>

On Wed, 26 Oct 2011 08:39:05 -0700, ExecMan wrote:

> So, CONSENSUS_RECOMMENDATIONS appears in the data dictionary as a TABLE,
> but it is not a just appears in DBA_OBJECTS as a table
> type, but then cannot be matched to DBA_TABLES.
> Any easy way to ignore this?
> Much thanks for your time.

There are two ways:

  1. Avoid nested tables, by specifying the "NESTED" flag, as shown in the example query.
  2. Use USER_SEGMENTS instead of the USER_TABLES and specify SEGMENT_TYPE='TABLE'. Nested tables do not have separate table segments.
Received on Wed Oct 26 2011 - 21:04:45 CDT

Original text of this message