It is Saturday night at 23:19. Time to go to bed after a hard migration day. Just a last clean-up query before finishing: Tap tap tap. Enter! - Oops!
SQL> UPDATE prospect_lists_prospects
SET prospect_list_id = '73ae6cca-7b34-c4a3-5500-5d0e2674dbb6';
Query OK, 4686 rows affected (0.21 sec)
Rows matched: 5666 Changed: 4686 Warnings: 0
A verification query to make sure I am in the mess:
SQL> SELECT prospect_list_id, COUNT(*)
FROM prospect_lists_prospects
GROUP BY prospect_list_id; …
