Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Views
Hi!
If you have privileges in the remote database try to query ALL_VIEWS/USER_VIEWS/SYS.DBA_VIEWS, these have a column called TEXT, that one contains the "source code" to the view (except if the view was created by SELECT * FROM ..., then the text column will show something else). Remember that the view name is stored in uppercase.
If you haven't got privileges you have to contact a developer or DBA responsible for the remote DBA to get help.
Frank
Contact the DBA or a developer on the remote database, and ask him
Erich <ese_at_ozemail.com.au> wrote in message
news:rpzz6.743$pO2.28023_at_ozemail.com.au...
> Hi everyone,
>
> I use Oracle 7.3 in conjunction with Access 97. Have tables linked to an
> Oracle database, located in another country. Some of the links are Views
> created from several tables.
>
> My question is, is there any way of examining how these views are
> constructed? The command in SQL "describe table/view" only results in
> showing the column names, without showing the table names.
>
> Help would be appreciated.
>
> Erich
>
>
Received on Sat Apr 07 2001 - 02:44:47 CDT