Re: existing view not in dba_views

From: <dave.ryan_at_swp.com>
Date: Mon, 5 Jun 2000 09:57:36 -0600
Message-Id: <10519.107718@fatcity.com>

Does the "view name" exist in dba_objects? Is the object type VIEW (or is it SYNONYM)? Gregory Conron <gconron_at_hfx.andara.com> on 06/02/2000 03:58:01 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Dave Ryan/ITC/SWP)

Subject: existing view not in dba_views

Interesting little bug (feature?) in Oracle 8.0.5.2 for HPUX. While trying to ensure a batch job will run properly tonight, I was verifying the views that were to be updated. Looking for the view_name in dba_views, I couldn't find anything even vaguely approaching the view name. However, I could easily do a describe and select from the view as both the schema owner and a different user. The view did not show up in either all_views nor user_views as the schema owner either.

Has anyone seen this before?

Cheers,
GC

Just as a note, all the view have
the same prefix - us_(view_name).
--

There is something inherently wrong with the world when Bill Gates is a famous billionaire and Dennis Ritchie lives in relative obscurity.
--

Author: Gregory Conron
  INET: gconron_at_hfx.andara.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 Mon Jun 05 2000 - 10:57:36 CDT