Database Security Products (MOSC)

MOSC Banner

About the redaction error ORA-28094

Hi there

Env info is: Oracle Database 19.13

and test this on many version. the error only occurs on 12.2 and above.

This is the test case below:

---------------------------------------------------------------

## create user

grant connect,resource,unlimited tablespace to u01 identified by u01;

conn u01/u01


## create table

create table u01.redact01 (a number,b varchar2(20),c varchar2(20));

insert into u01.redact01 values(1,'A','1234567890');

insert into u01.redact01 values(2,'B','1234567891');

commit;

select * from u01.redact01;



create table u01.normal01 (a number,b varchar2(20),c varchar2(20));

insert into u01.normal01 values(1,'A','1234567892');

insert into u01.normal01 values(2,'B','1234567893');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center