Re: Snapshot shows as INVALID in DBA

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Sun, 22 Jul 2001 09:37:15 -0700
Message-ID: <F001.00350E7C.20010722081703@fatcity.com>

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).

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.com

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 Sun Jul 22 2001 - 11:37:15 CDT

Re: Snapshot shows as INVALID in DBA_OBJECTs