<div>
You cannot alter the Start with of a sequence. You must drop it and recreate it.<br />
<br />
-- Get max value of current pk<br />
Select MAX(MY_PK) + 1 FROM MY_TABLE;<br />
<br />
-- returns...<br />
12345<br />
<br />
-- drop and recreate sequence<br />
DROP SEQUENCE MY_SEQUENCE;<br />
<br />
CREATE SEQUENCE MY_SEQUENCE START WITH 12345 increment by 1 ...yadda yadda yadda<br />
<br />
HTH,<br />
Mark<br />

</div>


You cannot alter the Start with of a sequence. You must drop it and recreate it.

-- Get max value of current pk
Select MAX(MY_PK) + 1 FROM MY_TABLE;

-- returns...
12345

-- drop and recreate sequence
DROP SEQUENCE MY_SEQUENCE;

CREATE SEQUENCE MY_SEQUENCE START WITH 12345 increment by 1 ...yadda yadda yadda

HTH,
Mark


<div>
This is fine but it will can be done every time.I want to have a procedure which will do it for all the sequences.
</div>


This is fine but it will can be done every time.I want to have a procedure which will do it for all the sequences.

<div>
<div class="content wysiwyg-content">
How to alter my sequence so that last value of sequence should be one more than the max value value of primary key cloumn of the table.<br />
It seems i need to have a procedure which will alter all the sequences at one shot.<br />
Could any one suggest me on this..<br />
<br />
<br />
<br />

</div>
</div>


How to alter my sequence so that last value of sequence should be one more than the max value value of primary key cloumn of the table.
It seems i need to have a procedure which will alter all the sequences at one shot.
Could any one suggest me on this..





Oracle Sequence - Last value need to be Max of primary key column +1

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.