RE: Oracle bug or I miss something

yes same user, by the way I just leave it with dba_sequences for the =
moment

I find no problem with all_triggers and all_synonyms

1:30 am already I want to go home, thanks all I am very tired....

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of David Sharples
Sent: Thursday, December 02, 2004 1:10 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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=20
oracle-l@xxxxxxxxxxxxx

> Select count(*) from all_sequences=3D20
>=20
> return 0
>=20
> Select count(*) from dba_sequences=3D20
>=20
> return correct # of sequence
--
http://www.freelists.org/webpage/oracle-l

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

Other related posts: