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!

Cannot drop object?

982153Feb 18 2013 — edited Feb 19 2013
I am simply following the CBT nuggets fundamentals course and did the following:


create sequence seq_int_by1
INCREMENT BY 1 START WITH 1 MINVALUE 1;

create sequence SEQ_testsequence
increment by 100 start with 1000
maxvalue 100000 minvalue 1000 cache 20;

rename seq_testsequence to seq_junkme;

drop sequence seq_junkme;

Everything works except the last statement for which i get the following error:

Error report:
SQL Error: ORA-00604: error occurred at recursive SQL level 1
ORA-20000: Cannot drop Object
ORA-06512: at line 2
00604. 00000 - "error occurred at recursive SQL level %s"
*Cause: An error occurred while processing a recursive SQL statement
(a statement applying to internal dictionary tables).
*Action: If the situation described in the next error on the stack
can be corrected, do so; otherwise contact Oracle Support.

Any ideas why i cannot drop this sequence?

Your help is greatly appreciated!
This post has been answered by Richard Harrison . on Feb 18 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2013
Added on Feb 18 2013
8 comments
936 views