Re: DBMS_METADATA

From: ExecMan <artmerar_at_yahoo.com>
Date: Wed, 26 Oct 2011 20:19:03 -0700 (PDT)
Message-ID: <689f3881-b996-445f-b43b-bcfadab0b7a2_at_g7g2000vbv.googlegroups.com>

On Oct 26, 9:04 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> 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

But that's just it......it appears in DBA_OBJECTS as a table, but not in DBA_TABLES:

SQL> select object_type from dba_objects where object_name = 'CONSENSUS_RECOMMENDATIONS'; OBJECT_TYPE

---

TABLE SQL> select nested from dba_tables where table_name = 'CONSENSUS_RECOMMENDATIONS'; no rows selected

Thoughts? Received on Wed Oct 26 2011 - 22:19:03 CDT