Yes, you need to need delete rows from this table. The recommendation is to 
create partitions in database, so it is easy to drop the partition. If you are 
going to run “DELETE” syntax, you have to be careful of redo logs in the 
database.

The recommendation is to use SolrCloud, because it has implicit purge using TTL 
(Time To Live) feature and also it can scale to larger dataset.

Thanks

Bosco



From:  Lune Silver <lunescar.ran...@gmail.com>
Reply-To:  <user@ranger.incubator.apache.org>
Date:  Monday, June 20, 2016 at 9:03 AM
To:  <user@ranger.incubator.apache.org>
Subject:  About the purge of the audit in a DB

Hello everyone.

I'm now using DB for audit for a short duration and I would like to purge it 
regularly.
Just to be sure, I have to delete the lines from the following table right ?
###
xa_access_audit
###

And that's it ?

BR.

Lune.

Reply via email to