After partition of table, masking is not completed
search cancel

After partition of table, masking is not completed


Article ID: 230918


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


During data masking for one of the table, we see mismatch in 'Masked XX of XXX' which is displayed on additional information under progress section.

The job has only one table in it. The table is partitioned table with 24 partition in it.

The partition type in Oracle was HASH partition on two columns however during masking we faced error as "ORA-14402: updating partition key column would cause a partition change " .


Release : 4.9

Component : Web Portal - Data Masking


Do not use Oracle ROWID with the partitioned tables, that is option ORACLEUSEROWID should be disabled when masking such tables. Disable this option in options file and re-run the job to resolve the issue.