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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
