Audit

ORA-09925: Unable to create audit trail file

PROBLEM: Users are getting below error, while trying to connect to the database. ERROR: ORA-09925: Unable to create audit trail file Linux-ia64 Error: 28: No space left on device Additional informatio...

ORA-28081: Insufficient privileges – the command references a redacted object

PROBLEM: While creating a table using CTAS, got below error: [crayon-5beb131494c09690488491/] CAUSE & SOLUTION The error indicates, that the objects which we are trying to access is redacted colum...

Unified audit trail in Oracle 12c

OVERVIEW:                 With oracle 12c, unified auditing has been introduced. It consolidates all audit trails into a single audit trail table. It will capture audit records from below sour...

How to move AUD$ table to another tablespace using DBMS_AUDIT_MGMT

If your AUD$ table is in SYSTEM and SYTEM tablespace, Then it is advised to move the AUD$ to a dedicated tablespace. Use below steps to move AUD$. [crayon-5beb131495f72821939093/] Use the dbms_audit_m...

Skip to toolbar