To: <SinardyXing@xxxxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
Date: Wed, 1 Dec 2004 12:07:25 -0500
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
