Re: Snapshot shows as INVALID in DBA

From: Dave Morgan <dave.morgan_at_cybersurf.net>
Date: Mon, 23 Jul 2001 10:16:54 -0700
Message-ID: <F001.00352147.20010723101256@fatcity.com>

Thanks Anita,

        I filed a TAR, altered my catalog.sql,
        recompiled 360 invalid objects, and now:

        It shows up in DBA_OBJECTS as a MATERIALIZED VIEW, 
        but the status is still INVALID, and the last 
        refresh data is shown as 1950!!!!

        I don't think this morning is 1950 but I've been wrong before :)

        Sigh ......

        And metaStink is basically down this morning so .....

        I'm still confused :)

Dave

"A. Bardeen" wrote:
>
> Dave,
>
> As someone else pointed out, this is a known bug
> (1188948).
>
> The issue is not with the dd, but that the view for
> DBA_OBJECTS did not get updated to handle the new
> object type value for materialized views. If you
> check the view definition (should be in catalog.sql)
> you'll see a decode statement that determines the
> object type. It doesn't have an entry for type 42,
> the new type for materialized views/snapshots, so
> that's why they're listed as "undefined."
>
> You can manually change the view definition, just keep
> in mind that you'll need to change it again after
> applying a patchset if the patchset replaces
> catalog.sql.
>
> It doesn't interfere with the way the snapshot/MV
> works, so it's considered annoying, but harmless. The
> script is fixed in 9i.
>
> HTH,
>
> -- Anita
>
> --- Dave Morgan <dave.morgan_at_cybersurf.net> wrote:
> > Hi All,
> > The subject says it all, 8.1.7 on Solaris 2.8
> >
> > The snapshot is accessable and correct.
> >
> > Anyone know a (supported) way to clean up the data
> > dictionary?
> >
> > TIA
> > Dave
> >

-- 
Dave Morgan
DBA, Cybersurf
Office: 403 777 2000 ext 284
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Morgan
  INET: dave.morgan_at_cybersurf.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jul 23 2001 - 12:16:54 CDT

Re: Snapshot shows as INVALID in DBA_OBJECTs