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: existing view not in dba_views

Re: existing view not in dba_views

From: Gregory Conron <gconron_at_hfx.andara.com>
Date: Mon, 5 Jun 2000 19:51:43 -0300
Message-Id: <10519.107763@fatcity.com>


On Mon, 05 Jun 2000, you wrote:
> Does the "view name" exist in dba_objects? Is the object type VIEW (or is it
> SYNONYM)?
Wipes egg off face and vows never to listen to $OTHER_DBA without checking the obvious.
Told the objects in question were views. Couldn't locate them in dba_views, send quick email off to list. Forget about it until now, and realize ...

ta-da!

they aren't views, they're tables :)

yeesh,
GC
 --
There is something inherently wrong with the world when Bill Gates is a famous billionaire and Dennis Ritchie lives in relative obscurity. Received on Mon Jun 05 2000 - 17:51:43 CDT

Original text of this message

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