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