Overview: Below are the questions asked to a candidate with 10 years of experience in Oracle DBA and postgres . There were 2 rounds. Round 1 : What are your day to day activities. And what is...
Audit
Useful oracle auditing related commands.
This articles contains useful command for both traditional and unified auditing . 1. How to enable auditing:(traditional) -- Auditing is disabled, when audit_trail is set to NONE SQL> show paramete...
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: SQL> create table test as select * from DBACLASS.CREDIT_CARD_INFO; create table test as select * from DBACLASS.CREDIT_CARD_INFO * ERROR ...
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$. select owner,segment_name,segment_type,tablespace_nam...