RE: Oracle bug or I miss something

  • From: "Sinardy Xing" <SinardyXing@xxxxxxxxxxxxx>
  • To: <davidsharples@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 2 Dec 2004 01:31:42 +0800

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

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

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


Other related posts: