Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de
Received on Thu Oct 18 2001 - 05:36:43 CDT
![]() |
![]() |