Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Snapshot shows as INVALID in DBA_OBJECTs

Re: Snapshot shows as INVALID in DBA_OBJECTs

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,


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US