I do have a shema named PRACTICE with its own table named EMPLOYEES.
The table has fields: empid,fname,sex and age.
Their data types are varchar2,varchar2,varchar2 and number respectively.
The fields also held values LA,Lensa,F and 21 respectively.
Being on the sys schema, I defined a policy for auditing purpose as follow.
When I tried to execute a statement- update employees set fname='Girma' where empid='LA',
I got the following error message:
ERROR at line 1:
ORA-28138: Error in Policy Predicate.
Please help me, I am waiting for your help. Thanks!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!