Updating sequence in oracle tranual dating services
For most users this will fix the problem and is very easy to do.How many times have we seen the request to “set back” or “set forward” a sequence to its original value. having a sequence, that start every time period (e.g.Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g.Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress.l_key := p_tbl
NEXTVAL FROM dual; ALTER SEQUENCE gokhan.sample_seq INCREMENT BY 1; SELECT last_number FROM user_sequences WHERE sequence_name = 'SAMPLE_SEQ'; LAST_NUMBER ----------- 500 CREATE OR REPLACE PROCEDURE SYS.On the other hand, we can use a trick to change the value of a sequence without recreating it.Let’s say we have a sequence and its value is 1000, and we want to set it to 500.Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community.Founding member, and vice president of Turkish Oracle User Group (TROUG).
Search for updating sequence in oracle:
ALTER SEQUENCE seq_cache INCREMENT BY xx In RAC, sequence enqueue delays are shown in the eq_type column of the gv$enqueue_stat view.