Re: Looking into all the tables of a schema
Date: Thu, 17 Jan 2008 02:35:08 -0800 (PST)
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