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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l