Monday, 1 April 2019

How to purge AUD$?

1. Count the number of rows
------------------------------------
select count(*) from AUD$;
it will show the number of rows

2. Then take the export backup
--------------------------------------
NOTE:-export backup must be taken inside the perticular mountpoint where it's intended to keep the DMP file

exp file=/bkp/audit_bkp/exp_aud_Date.dmp log=/bkp/audit_bkp/exp_aud_Date.log tables=AUD$

password: / as sysdba

After Export Backup Check the number of rows the difference may b there.
There may or may n't b large difference

3.Clear the Table and Keep the Structure
------------------------------------------
Truncate table AUD$

4.Check again
-------------------------------------------
select count(*) from AUD$;

How to login on Oracle Cloud Console?

Login Steps for Oracle Cloud Console To sign in to Oracle Cloud Console, We need to open up the corresponding region console URL for Free Ti...