How set Auto_Increment from a select?
Hi,
I have a table with an auto_increment column. I found the AutoIncrement value = 123456789020741. Don't ask me why. I set the Autoincrement in a right value, but after some time I found it too big.
How can I make the Auto_increment in this way:
Alter Table MyTable Auto_Increment = (Select Max(AI) + 1 From MyTable)
?
Thank you
Subject
Written By
Posted
How set Auto_Increment from a select?
August 19, 2014 04:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.