Data Masking Export Job Failed with ORA-00942
(Doc ID 2792472.1)
Last updated on AUGUST 20, 2021
Applies to:Oracle Data Masking and Subsetting - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Data masking job (mask in export) failed on Windows server. Although OEM show this job succeeded, actually it failed in the middle and didn't generate data pump files.
Masking Job log has below error:
ORA-06550: line 6, column 83:
PL/SQL: ORA-00942: table or view does not exist
If Generated Masking Script is executed directly on the DB. It works fine. However, it fails when is executed from OEM.
Implement Data Masking on DB hosted on windows server.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document