Question regarding workload capture and database replay

Hi

Oracle 19c

I was reading regarding RAT, and some questions arise.

Lets say, we will have two systems:

• production system
• test system

Test database was created from production database. Some sensitive data sets were scrambled on test system (some names and SSN codes, etc) after the data was taken from production.

Several months have passed and both databases live their own lives. Now clearly, there is way more workload in production, so there have more rows in tables. At present time, for example table tab1 has the following max(id)-s:

• production - max(id) for table tab1 => 90 000
• test - max(id) for table