RE: Oracle bug or I miss something

Here is what I got on my 8173 oracle DB. The use has DBA priv.

ISI_at_rex-SQL> Select count(*) from all_sequences;  

  COUNT(*)

       205  

Elapsed: 00:00:00.42
ISI_at_rex-SQL> Select count(*) from dba_sequences;  

  COUNT(*)

       205  

Elapsed: 00:00:00.12

Guang

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Sinardy Xing Sent: Wednesday, December 01, 2004 11:59 AM To: Oracle-L_at_freelists.org
Subject: Oracle bug or I miss something

Hi all,

Select count(*) from all_sequences=20

return 0

Select count(*) from dba_sequences=20

return correct # of sequence

Sinardy
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Dec 01 2004 - 11:06:46 CST