Re: Looking into all the tables of a schema

From: gazzag <>
Date: Thu, 17 Jan 2008 02:35:08 -0800 (PST)
Message-ID: <>

On 17 Jan, 07:55, Ratan <> 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

Original text of this message