My Oracle Support Banner

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 13.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

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
errorExitOraError!

If  Generated Masking Script is executed  directly on the DB. It works fine. However, it fails when is executed  from OEM. 

Changes

Implement Data Masking on DB hosted on windows server. 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.