How to Purge Audit Information From UCM Tables (Doc ID 1482441.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version 10.1.3.5.0 and later
Information in this document applies to any platform.

Goal

Your company policies do not allow the configuration of the autoextend property on tablespaces. One result of this is that as certain tables grow larger, you see this error:


This is especially true of tables containing UCM audit data like:

DOCUMENTHISTORY

DELETEDROWS

ARCHIVEHISTORY

WORKFLOWHISTORY


Eventually the tablespace(s) fill up and UCM crashes. You would like to know whether there is a way to purge these tables or limiting the audit level.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms