The Vertica Database Forums

Anyone know if there is a function to clear the LICENSE_AUDITS system table?

I would hope that there’s no way to clear it. Otherwise HP would have no way to know if you’ve been within your license limit.

I see from the LICENSE_AUDITS view definition that it’s basedon vs_license_audits rather than a dc table which could be flushed.

—Sharon

Julie wrote:Anyone know if there is a function to clear the LICENSE_AUDITS system table?

Create a new cluster.