RE: existing view not in dba

From: Jain, Akshay <Akshay.Jain_at_cit.com>
Date: Mon, 5 Jun 2000 12:51:26 -0400
Message-Id: <10519.107724@fatcity.com>

Is the name of lower/mixed case?

Akshay Jain

Newcourt-CIT
Tel. (416) 507-5385
mailto:Akshay.Jain_at_cit.com

-----Original Message-----
From: Gregory Conron [mailto:gconron_at_hfx.andara.com] Sent: Friday, June 02, 2000 5:58 PM
To: Multiple recipients of list ORACLE-L 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 - 11:51:26 CDT

RE: existing view not in dba_views