Re: Looking into all the tables of a schema

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.
>
> HTH
>
> -g

Thanks a ot. Now its completely working. Received on Fri Jan 18 2008 - 00:17:20 CST