Re: Why I don't use all_tab_columns

Hallo Markus,

ALL_TAB_COLUMNS describes all cols of all tables, views and clusters accessible to the user that issues the command. So the result of your query varies.

Gruesst: Guido

"Markus Boehmer" wrote...
> Here we go,
>
> I tried to use all_tab_columns but it hasn't worked.
>
> "SELECT DISTINCT OWNER FROM ALL_TAB_COLUMNS" returns only nine
> owners.
> If doing the same as dba I get 49 owners in return.
> Am I missing some rights?
>
> Any further suggestions are welcome.
>
> Greetings
> Markus
>
Received on Thu Jan 09 2003 - 06:15:41 CST