Re: DBMS_METADATA

From: ExecMan <artmerar_at_yahoo.com>
Date: Wed, 26 Oct 2011 20:20:43 -0700 (PDT)
Message-ID: <5e408e9c-ff04-4773-9517-0cbc2b65907d_at_v5g2000vbh.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

My follow up. Pretty messed up:

SQL> select segment_type from user_segments where segment_name = 'CONSENSUS_RECOMMENDATIONS'; SEGMENT_TYPE

---

NESTED TABLE Why the hell does it say type TABLE and not appear in DBA_TABLES. Real nice Oracle. I expect something like that from Microsoft. Received on Wed Oct 26 2011 - 22:20:43 CDT