Change this line to:Originally posted by silver40
SQL> Create or Replace Sequence ID
......
SQL> Create Sequence ID
and you'll be fine. You can't use OR REPLACE option with sequences.
BTW, I hope you are aware that it is almost unavoidable to have "gaps" (mising numbers in your ID column) when using sequences.




Reply With Quote