Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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.Received on Fri Jun 02 2000 - 15:54:21 CDT