data redistribution based on update action on specific column

I have a huge data which is distributed on 8 databases in same table name. Data distribution done based on column named subid (filled by a sequence) , in a way data between 1 and N exist in DB1, N+1 till M in DB2, M+1 till P in DB 3...... We have activity to update these subids which will mix the data. I need the best scenario ( performance wise) to redistribute the data into 8 databases with a minimum time based on the new updated userid. I can do db link and create synonyms between databases to see all from same DB.

Can I use trigger to fire on update to insert into other tables based on new value for SUBID and delete current record?