I have the following query

insert into tablex
select rowstamp, col1,col2,col4
from tablex2

Now the issue is that the rowstamp in the first table is significantly greater than the rowstamp in the destination and i am not sure i want this huge difference in my destination table.

Is there a way I can rowstamp the destination table with its next rowstamp and not the one from the source table.

Obviously i can't drop the rowstamp in the query or i get a message saying that i do not have enough columns.

Thanks