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

Home -> Community -> Mailing Lists -> Oracle-L -> existing view not in dba_views

existing view not in dba_views

From: Gregory Conron <gconron_at_hfx.andara.com>
Date: Fri, 2 Jun 2000 17:54:21 -0300
Message-Id: <10516.107615@fatcity.com>


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.
Received on Fri Jun 02 2000 - 15:54:21 CDT

Original text of this message

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