Re: Looking into all the tables of a schema

On 17 Jan, 07:55, Ratan <ratan.nit..._at_gmail.com> wrote:
> Thanks a lot Jim. I have got my answer.
>
> But the problem is, I have to login as SYSDBA to execute this query.
> As an ordinary user, I cant execute, because, then it cant find the
> dba_tab_columns table. So, what is the alternative?- Hide quoted text -
>
> - Show quoted text -

You don't have to log in as SYS dba to see the DBA_TAB_COLS view (note, not DBA_TAB_COLUMNS). SYSTEM can see this view.

Also, as well as the DBA_* views, there are equivalent USER_* and ALL_* views.

HTH -g Received on Thu Jan 17 2008 - 04:35:08 CST