Re: DBMS_METADATA

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 27 Oct 2011 02:04:45 +0000 (UTC)
Message-ID: <pan.2011.10.27.02.04.45_at_gmail.com>

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 table.......it 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.

-- 
http://mgogala.byethost5.com

Received on Wed Oct 26 2011 - 21:04:45 CDT