I'm using the new feature to create a sequence/trigger pair on a table. If an error occurs during insert, the sequence still gets incremented. Is there a way to reset the sequence so that the next value will be sequential to those already used? I tried recreating the sequence for example so that it would start at 1 again, but the next insert inserted the value 21 (as if the sequence had never been reset). Also, looking at the sequence under the sequences tab does not show what the next sequence value will be.
WORKAROUND:
None
STATUS:
Submit an enhancement request on Toad World Idea Pond. Voting results will be considered in a future release of Toad for Oracle.
