RE: Oracle bug or I miss something

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

ISI@rex-SQL> Select count(*) from all_sequences;
 
  COUNT(*)
----------
       205
 
Elapsed: 00:00:00.42
ISI@rex-SQL> Select count(*) from dba_sequences;
 
  COUNT(*)
----------
       205
 
Elapsed: 00:00:00.12


Guang


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Sinardy Xing
Sent: Wednesday, December 01, 2004 11:59 AM
To: Oracle-L@xxxxxxxxxxxxx
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

Other related posts: