Re: Looking into all the tables of a schema
Date: Thu, 17 Jan 2008 22:17:20 -0800 (PST)
On Jan 17, 3:35 pm, gazzag <gar..._at_jamms.org> wrote:
> 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.
Thanks a ot. Now its completely working. Received on Fri Jan 18 2008 - 00:17:20 CST