Re: Trying to create a simple view against system view. Don't think possible

G'day Techie .. First thing is that the statement below is syntactically incorrect. Should read
"Create view .... AS SELECT ...".

But in case it was a typo while you were compiling the post ... what error message are you seeing? If it is "table or view does not exist" then the chances are that the user attempting to create a view just doesn't have access to the underlying view dba_tab_columns. If the intention is to create a view to be usable by non-DBA users, try using all_tab_columns instead.

Hope that helps - Paul.

Techie wrote:

> I am trying to create a view against the dba_tab_columns data dictionary
> view. It is a view, not a table. In normal cases standard SQL allows you
> to create a view against a view, but in this case I don't believe it is
> supported under Oracle. Is there are a workaround.
>
> Eg "create view testview (table_name) select as table_name from
> dba_tab_columns" won't work.

--
=====================================================================
Paul Harrington - Oracle DBA/Developer, Orbiscom, Dublin.
Email:  paulh_at_io.com. Please note: I discard all BCC messages unread.
=====================================================================