RE: Oracle bug or I miss something

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Thu, 2 Dec 2004 01:27:42 +0800
Message-ID: <7534CC34CD1D9F49BB05A00B9C6F20F401853086@antares.bcsgroup.com.sg>

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_at_bt.com [mailto:arul.kumar_at_bt.com] Sent: Thursday, December 02, 2004 1:10 AM To: Sinardy Xing
Cc: Oracle-L_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sinardy Xing Sent: 01 December 2004 16:59
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:27:23 CST