are they run as the same user - if you dont have select privelege on the seuqnce then you wont see it in all_sequences On Thu, 2 Dec 2004 00:59:11 +0800, Sinardy Xing oracle-l@xxxxxxxxxxxxx > Select count(*) from all_sequences=20 > > return 0 > > Select count(*) from dba_sequences=20 > > return correct # of sequence -- //www.freelists.org/webpage/oracle-l