sounds like the user doesn't own any / may not have access to those
sequences?
And, have you checked the OWNER column of dba_sequences?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sinardy Xing
Sent: 01 December 2004 16:59
To: Oracle-L@xxxxxxxxxxxxx
Subject: Oracle bug or I miss something
Hi all,
Select count(*) from all_sequences=3D20
return 0
Select count(*) from dba_sequences=3D20
return correct # of sequence
Sinardy
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
