Re: Oracle bug or I miss something

are they run as the same user - if you dont have select privelege on the seuqnce then you wont see it in all_sequences

On Thu, 2 Dec 2004 00:59:11 +0800, Sinardy Xing oracle-l_at_freelists.org

> Select count(*) from all_sequences=20
>
> return 0
>
> Select count(*) from dba_sequences=20
>
> return correct # of sequence

--
http://www.freelists.org/webpage/oracle-l