RE: Oracle bug or I miss something

What user id did you use for=20

Select count(*) from all_sequences;

If it wasn't sys, system , a DBA user then all user_sequences will give you is what you as a user 'own' or have been granted permissions on...nothing else.

Only DBA_anything has ALL of the objects in the database and has the additional column of owner

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sinardy Xing Sent: Wednesday, December 01, 2004 10:59 AM 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:13:14 CST