Re: OPO View Not Showing Tables

From: Mike Kranzdorf <mikek_at_krt.com>
Date: 1997/04/15
Message-ID: <mikek-1504970651530001_at_pdl-ts1-11.jvnc.net>#1/1


In article <19970414220900.SAA11427_at_ladder01.news.aol.com>, roywagner_at_aol.com (Roy Wagner) wrote:

> I have recently installed Oracle Power Objects 2.0 and am having a program
> displaying the Tables that are used to create a View. They are NOT being
> displayed for existing views. I see them when I create a new view, but
> after saving it and trying to edit it, all I see is the field list. (I'm
> using the MLDATA application and also a copy I created the OPO20 SQL
> file.)

This is the way it is. If you didn't create the view in OPO, you don't see the tables. The code that created the view (and hence the source tables) can be found in [dba|user]_views. i.e. from SQL*Plus type

SELECT * FROM sys.user_views WHERE VIEW_NAME = 'the_view_name';

assuming you are logged in as the owner of the view.

> Also, how do I rename a view?

You can't. You can create a synonym for it or drop and recreate it. Regards,

Mike Kranzdorf              mikek_at_krt.com
Kranzco Realty Trust        http://www.krt.com
Oracle Power Objects FAQ http://www.krt.com/mac/opofaq.html Received on Tue Apr 15 1997 - 00:00:00 CEST

Original text of this message