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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
