Impdp with REMAP_SCHEMA does not modify Policy with new schema name (Doc ID 2879694.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Following error can be observed in IMPDP log file.

W-1 Processing object type SCHEMA_EXPORT/TABLE/RADM_POLICY
Object type RADM_POLICY failed to create with error:
ORA-01918: user <source schema name> does not exist

Failing sql is:
BEGIN DBMS_REDACT.ADD_POLICY(object_schema => '"<source schema name>"', ..........;
DBMS_REDACT.ALTER_POLICY (object_schema => '"<source schema name>"', .........;
DBMS_REDACT.ALTER_POLICY (object_schema => '"<source schema name>"', .......;
END;

Changes

 IMPDP done with remap_schema clause

Cause

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