my intention as follow -------------------------- doesn't work -------------------------- spool /tmp/~drop_sequence.sql select 'drop sequence ' || owner || '.' | sequence_name ||';' from all_sequences; spool off @/tmp/~drop_sequence.sql host rm -f /tmp/~drop_sequence.sql -------------------------- work -------------------------- spool /tmp/~drop_sequence.sql select 'drop sequence ' || owner || '.' | sequence_name ||';' from dba_sequences; spool off @/tmp/~drop_sequence.sql host rm -f /tmp/~drop_sequence.sql -----Original Message----- From: arul.kumar@xxxxxx [mailto:arul.kumar@xxxxxx] Sent: Thursday, December 02, 2004 1:10 AM To: Sinardy Xing Cc: Oracle-L@xxxxxxxxxxxxx Subject: 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@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