Re: changing seq number
Date: Thu, 30 Jan 2014 20:09:27 +0000
Message-ID: <CF101B46.3F524%Mark.Bobak_at_ProQuest.com>
It should be as simple as:
Alter sequence my_seq increment by 10;
Select my_seq.nextval from dual;
Alter sequence my_seq increment by 1;
If that doesn't work, please reply with cut-n-paste from your SQL*Plus session, showing exactly what you see.
-Mark
--
Mark J. Bobak, Lead Oracle DBA
ProQuest | 789 E. Eisenhower Pkwy | Ann Arbor, MI 48108-3218 USA | +1 734 997 4059
www.proquest.com<http://www.proquest.com/>
ProQuest... Start here. 2013 InformationWeek 500 Top Innovator
From: <Zelli>, "brian.zelli_at_roswellpark.org<mailto:brian.zelli_at_roswellpark.org>" <brian.zelli_at_roswellpark.org<mailto:brian.zelli_at_roswellpark.org>> Reply-To: "brian.zelli_at_roswellpark.org<mailto:brian.zelli_at_roswellpark.org>" <brian.zelli_at_roswellpark.org<mailto:brian.zelli_at_roswellpark.org>> Date: Thursday, January 30, 2014 at 2:59 PM To: "oracle-l (oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>)" <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: changing seq number
Ok, I try and alter a seq number and it doesn't seem to take. I change the increment and from what I read if I run the nextval command it is supposed to increment it but it doesn't. How can I change the last_value to exactly what I need it to be?
Brian
This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 30 2014 - 21:09:27 CET