Re: Sequence drop does not work sometime

On Thu, 18 Oct 2001 10:14:08 +0530, "Pinto" <reach_me_at_india.com> wrote:

>Hello,
>I have a vc++ code that creates a table in the database and also a
>corresponding sequence for that table. after all the inserts and updates, at
>the end of the code, i drop the sequence. next time when the code is
>executed, if the same table is given as i/p parameter, the sequence is
>created with start with of the sequence same as the max+1 value available in
>the table. if it is a different table, a new sequence is created.
>the problem is that the sequence drop statement fails sometime. what can be
>the reason for the drop sequence operation to fail.
>
>warm regards,
>Pinto.
>
>
>

The general sytax is

DROP SEQUENCE [<owner>.]<sequence_name>;

Therefore you can drop sequence that you own. And you can drop other sequences, if you have the appropriate privileges. Typically you will work as a user with privilege DBA to drop someone other's sequences.

The DROP-statement fails, because

• the sequence doesn't exist in your user/schema
• you specified the wrong owner

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Thu Oct 18 2001 - 05:36:43 CDT