RE: Oracle bug or I miss something
- From: "Hollis, Les" <Les.Hollis@xxxxxx>
- To: <SinardyXing@xxxxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 1 Dec 2004 11:12:46 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sinardy Xing
Sent: Wednesday, December 01, 2004 10:59 AM
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
Other related posts:
