Not Able To Perform Data Redaction On Tables . (Doc ID 2894006.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.15.0.0.0 and later
Information in this document applies to any platform.

BEGIN

DBMS_REDACT.ALTER_POLICY(

OBJECT_SCHEMA => 'TEST',

OBJECT_NAME => 'ALERT_TEST_SAMPLE_LOG',

POLICY_NAME => 'REDACT_TBL_TEST',

COLUMN_NAME => 'SENDER_DETAIL',

FUNCTION_TYPE => DBMS_REDACT.PARTIAL,

FUNCTION_PARAMETERS => 'VVVVVVVVVVVV,VVVVVVVVVVVV,#,1,5',

EXPRESSION => 'sys_context(''USERENV'',''SESSION_USER'') != ''TEST'''

);

END;

Error report -

ORA-28064: The redaction function is not valid.

ORA-06512: at "SYS.DBMS_REDACT_INT", line 3

ORA-06512: at "SYS.DBMS_REDACT", line 21

ORA-06512: at line 2

28064. 00000 - "The redaction function is not valid."

None

	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

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