Exported and imported a table containing an identity column and the last number conflicts with the data?
No problem, just execute the following:
alter table table_name modify column_name generated as identity start with limit value;
Oracle will scan the table for the maximum value and set the last number to that number + increment.
Thanks to the following article of Jonathan Lewis for explaining how to do it, I believe that the documentation of Oracle 19 is missing this info whilst Oracle 23 docs are mentioning this option.
No comments:
Post a Comment
I appreciate your comment however bear in mind that I might not have the time to reply soon.
Normally I do not reply to all comments but I am glad if you found something useful or if you learned something new, in that case I strongly encourage you to promote the article with the +1 google button.
Flavio