RE: Oracle bug or I miss something

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sinardy Xing Sent: 01 December 2004 16:59
To: Oracle-L_at_freelists.org
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 Received on Wed Dec 01 2004 - 11:08:20 CST