Creation of CDB 12.2

SQL> alter system set compatible='12.2.0.1' scope=spfile ; System altered. SQL> startup force nomount ORACLE instance started. Total System Global Area 1073741824 bytes Fixed Size 8801008 bytes Variable Size 671089936 bytes Database Buffers 390070272 bytes Redo Buffers 3780608 bytes SQL> create database cdb1 user sys identified by oracle user system identified by oracle extent management local … Continue reading Creation of CDB 12.2

Advertisements

Purge Job for Auditing

There is not much to write about this. It's a purge job for the audit trail 😀 E: it will not work 😅 i have changed it a little 😅 DECLARE lat TIMESTAMP := TO_TIMESTAMP('30-06-17 00:00:00.00','DD-MM-YYYY HH24:MI:SS.FF'); BEGIN dbms_audit_mgmt.init_cleanup(AUDIT_TRAIL_TYPE => dbms_audit_mgmt.audit_trail_aud_std, DEFAULT_CLEANUP_INTERVAL => 1); DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP(audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, last_archive_time => lat); DBMS_AUDIT_MGMT.CREATE_PURGE_JOB(AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, AUDIT_TRAIL_PURGE_INTERVAL => … Continue reading Purge Job for Auditing