Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error Dropping Sequence

710115Jul 15 2009 — edited Jul 15 2009
When I try to run the following command:

drop sequence mst_scenario_attribute_wbs_SQ;

I get the following error:

ORA-02289: sequence does not exist

I know it exists because I see it when I query:

select *
from sys.all_sequences s

I also see it in PL/SQL Developer

I tried to purge the recycle bin, but that didn't do anything. Also, the DB has been restarted. Any ideas?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2009
Added on Jul 15 2009
6 comments
745 views